testhttp500

IBMCognosAnalyticsVersion11.
0.
0TroubleshootingGuideIBMProductInformationThisdocumentappliestoIBMCognosAnalyticsversion11.
0.
0andmayalsoapplytosubsequentreleases.
CopyrightLicensedMaterials-PropertyofIBMCopyrightIBMCorp.
2005,2018.
USGovernmentUsersRestrictedRights–Use,duplicationordisclosurerestrictedbyGSAADPScheduleContractwithIBMCorp.
IBM,theIBMlogoandibm.
comaretrademarksorregisteredtrademarksofInternationalBusinessMachinesCorp.
,registeredinmanyjurisdictionsworldwide.
OtherproductandservicenamesmightbetrademarksofIBMorothercompanies.
AcurrentlistofIBMtrademarksisavailableontheWebat"Copyrightandtrademarkinformation"atwww.
ibm.
com/legal/copytrade.
shtml.
Thefollowingtermsaretrademarksorregisteredtrademarksofothercompanies:vAdobe,theAdobelogo,PostScript,andthePostScriptlogoareeitherregisteredtrademarksortrademarksofAdobeSystemsIncorporatedintheUnitedStates,and/orothercountries.
vMicrosoft,Windows,WindowsNT,andtheWindowslogoaretrademarksofMicrosoftCorporationintheUnitedStates,othercountries,orboth.
vLinuxisaregisteredtrademarkofLinusTorvaldsintheUnitedStates,othercountries,orboth.
vUNIXisaregisteredtrademarkofTheOpenGroupintheUnitedStatesandothercountries.
vJavaandallJava-basedtrademarksandlogosaretrademarksorregisteredtrademarksofOracleand/oritsaffiliates.
ContentsChapter1.
Troubleshootaproblem1Troubleshootingresources1IBMSupportPortal2Problemdetermination2Servicerequests2FixCentral2Knowledgebases2LogFiles3ErrorMessages5Coredumpfiles6Turnoffcorefilecreation6MetricDumpFile.
6EnableMetricDumpinginIBMCognosAdministration7Changethemetricdumpconfiguration.
xmlfile8MicrosoftWindowsEventViewer8Samples8Chapter2.
Installationandconfigurationproblems.
11ProblemsstartingIBMCognosAnalytics.
11CFG-ERR-0106errorwhenstartingtheIBMCognosserviceinIBMCognosConfiguration11CryptographicerrorwhenstartingIBMCognosAnalytics13UnabletostarttheIBMCognosservicebecausetheportisusedbyanotherprocess13IBMCognosservicedoesnotstartorfailsafterstarting14IBMCognosAnalyticsserverfailstostartandgivesnoerrormessage.
14ServernotavailablewhenstartingIBMCognosAnalytics15Cannotlogontoanamespace18IBMCognosservicesfailtorestartafteranetworkoutage.
18Nowarningthatinstallingalaterversionwillautomaticallyupdatetheearlierversionofthecontentstore.
.
19Downloadofresourcefails19Db2returnsSQL1224NerrorwhenconnectingfromAIX19ContentManagererrorwhenstartingIBMCognosAnalytics19ContentManagerfailstostartortakesalongtimetostart20ManagingtheConfigurationServer21DPR-ERR-2014errorinthelogfileontheContentManagercomputer.
22Non-ASCIIcharactersininstallationdirectorycauserun-timeerrors23CannotOpenaMicrosoftCubeorPowerCube.
23ThepageisnotshownwhenopeningaportalafterinstallingIBMCognosAnalytics.
24DPR-ERR-2058ErrorDisplaysinWebBrowserWhenStartingIBMCognosAnalytics.
24DPR-ERR-2022errordisplaysinWebbrowserwhenstartingIBMCognosAnalytics26CorruptcharacterswhileinstallinginsomelanguagesonLinux26Unabletodownloadthecognos.
xtsfile27Applicationserverstartupscriptfails.
27DeployingtoanOracleApplicationServerwhenIBMWebSphereApplicationServerfails27Accentedordouble-bytecharactersmaynotdisplaycorrectlywheninstallingIBMCognosAnalyticsonLinux28RSV-SRV-0066asoapfaulthasbeenreturnedorRQP-DEF-0114theusercancelledtherequesterrorsdisplayinhighuserloadenvironments28ProblemsconfiguringIBMCognosAnalytics28RunningDatabaseandIndexCleanupScripts29Errortryingtoencryptinformationwhensavingyourconfiguration31ProblemsgeneratingcryptographickeysinIBMCognosConfiguration32CAM-CRP-1315errorwhensavingconfiguration32CAM-CRP-0221errorwhenloggingintotheportal32Manuallychangingtheinstallationdirectorynameaffectsinstallationsrunningunderanapplicationserver.
.
33ConfigurationdataislockedbyanotherinstanceofIBMCognosConfiguration34Unabletoexitatabsequencewhenusingkeyboard-onlynavigationinIBMCognosConfiguration34iiiUnabletosaveyourconfiguration.
34JavaerrorwhenstartingIBMCognosConfiguration.
35CryptographicerrorwhenstartingIBMCognosConfiguration35RestartingtheIBMCognosservicetoapplyconfigurationsettings35CM-CFG-029errorwhentryingtosaveaconfigurationthatspecifiesaMicrosoftSQLServercontentstore.
.
36Db2notfounderrorforLinuxonSystemz.
36DPR-ERR-2079whenContentManagerconfiguredforfailover36ImportingalargedeploymentinWindowscrashestheJavavirtualmachine37CCL-BIT-0006errormessagewhenusingWebSphereApplicationServeronaheavilyloadedsystem.
.
.
.
37FontonUNIXnotfoundwhenstartingIBMCognosConfiguration37ESSBASEPATHcannotbedetected38ProblemstestingdatasourceconnectionswithIBMCognosAnalyticsdeployedonSAPNetWeaverApplicationServer7.
1.
1onUNIX39GroupmembershipismissingfromActiveDirectorynamespace39QueryfailswhenusingOracleEssbaseServer40ErrorsdisplayedwhendeployingtoOracle10GApplicationServer41CGItimeouterrorwhileconnectedtoIBMCognosAnalyticsthroughaWebbrowser41DesktopiconsorIBMCognosConfigurationwindowflickeronWindows42Missingtranslationsforobjectnamesinsomelocales42Chapter3.
SecurityProblems45ProblemsSettingUpSecurity45AccesstoEntriesIsDeniedDuringDeployment45PrompttoChangePasswordsWhenLoggingontoanActiveDirectoryNamespace45UnabletoLogon45CertificateAuthorityErrorWhenLoggingon46HTTPSDRP-ERR-2068ErrorinLogFileWhennoErrorIsReportedDuringaSwitchtoHTTPS46EntriesDoNotAppearforaMemberofaNewlyCreatedGroup46ExistingPasswordsMaynotWorkinanSAPNamespace47UsersAreRepeatedlyPromptedforCredentialsWhenTryingtoLogOntoanSAPNamespace48ProblemsUsingAuthenticationProviders48Unauthorizeduserscanrunreports48ExpiredPasswordErrorAppearsWhenUsingActiveDirectoryServer48SingleSignonIsNotWorkingWhenUsingActiveDirectoryServer.
49UnabletoIdentifyRequiredSAPPermissions49UnabletoAccessIBMCognosAdministrationWhenanNTLMNamespaceIsUsedandSingleSignonIsEnabled50UnabletoAutomaticallyConnecttoanSAPBWDataSourcebySSO50Chapter4.
Administrationproblems53Datasourceconnectionproblems53CannotConnecttoanSQLServerDatabaseUsinganOLEDBConnection53IntermittentProblemsConnectingtoanSQLServerDatabase53ContentManagerConnectionProbleminOracle(ErrorCM-CFG-5036)54CannotConnecttoanOLAPDataSource54UnabletoSelectODBCastheTypeofDataSourceConnection54ErrorWhenCreatingaDataSourceConnectiontoaPowerCube55Otheradministrationproblems55RestartingServersAfterSolvingContentStoreProblems55AnUpdateorDeleteRequestFails55HigherLoggingLevelsNegativelyAffectPerformance56UnabletoIdentifySAPBWVersionandCorrections.
56SBW-ERR-0020ErrorWhenRunningReportsBasedonSAPBWDataSources57LinkstoReferencedContentObjectsareBrokenFollowingDeployment57TableorViewDoesnotExistforSampleDatabase57CNC-ASV-0007ErrorWhenCallingaReportTriggerFromaWebServiceTask58JavaVirtualMachineFailsUnderLoadWhenMultipleUsersRunIBMCognosWorkspaceDashboards.
.
.
58OracleEssbaseVersion11SubstitutionVariablesMustBeSetattheCubeLevel58CNC-SDS-0413Errorwhenexecutingascheduledreport59ivIBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideChapter5.
ProblemsAuthoringReports61ProblemsCreatingReports61ChartLabelsOverwriteOneAnother61ChartShowsOnlyEverySecondLabel61ChartGradientBackgroundsAppearGrayinInternetExplorer61DivisionbyZeroOperationAppearsDifferentlyinListsandCrosstabs62Applicationerrorappearswhenupgradingareport62NestedListReportContainingaDataItemThatisGroupedMoreThanOnceDoesNotRunAfterUpgrade.
.
62BackgroundColorinTemplateDoesnotAppear63SubtotalsinGroupedLists63MetadataChangeinOracleEssbaseNotReflectedinReportsandintheStudios63RelationshipsNotMaintainedinaReportWithOverlappingSetLevels63CreatingSectionsonReportsThatAccessSAPBWDataSources64ErrorCharacters(--)AppearinReports64FunctionUnreliablewithSets65Columns,Rows,orDataDisappearWithSSAS2005Cubes65UnexpectedCellFormattinginReports66ReportDifferencesBetweenTM1ExecutiveViewerandIBMCognosAnalyticswithTM1DataSources.
.
.
66OrderofMetadataTreeDiffersforTM1DataSources66MSR-PD-0012errorwhenimportingexternaldata66MSR-PD-0013errorwhenimportingexternaldata66ProblemsCalculatingData67SummariesinQueryCalculationsIncludeNullswithSAPBWDataSources67NullResultsforCalculationsUsingSAPBWDataSources67UnexpectedSummaryValuesinNestedSets67IncorrectResultsinSummariesWhenUsingOLAPDataSources68IncorrectResultswithIBMCognosPowerCubesandTimeMeasures70UnexplainedDiscrepanciesinNumberCalculations70Errorwhenfilteringona_make_timestampcolumn.
72ProblemsDistributingReports72AReportLinkinanEmailNotificationDoesNotWork72ReportContainsNoData.
72HyperlinksinEmailMessagesAreStrippedOutWhentheAgentisSaved73ErrorsWhenRunningWebServiceTasks73CannotCalltheSDKfromEventStudio74Chapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses75ProblemsRunningReportsandAnalyses75Summariesinareportdonotcorrespondtothevisiblemembers75UnexpectedResultsforAnalysisStudioReportsUsingSuppressionandNestedRows77DefiningLanguagesforOLAPDataSources77CrosstabShowsPercentageButChartShowsValues.
77CannotDrillwhenCaptionRepresentsaBlankoraZero-lengthString78DPR-ERR-2082TheCompleteErrorHasBeenLoggedbyCAFWithSecureErrorID78QueryStudioDoesNotGenerateaSELECTDISTINCTstatementifaColumnisAliasedWithoutUsingtheActualColumnName78QE-DEF-0288CannotFindtheDatabaseintheContentStore.
78ParseErrorsWhenOpeningorRunninganUpgradedReport79OverflowErrorOccursWhenaValueinaCrosstabIsMoreThan19Characters79IBMCognosAnalyticsRunsOutofTEMPSpace79AReportDoesNotRunasExpected79PerformanceIssueswhenShowingMultipleAttributesUsingDimensionally-modeledRelationalDataSources80ErrorOccursinJapaneseInternetExplorer7WhenRunninganExcelReportinAnalysisStudio80TheORA-00907ErrorAppearsWhenRunningaReport80ScheduledReportsFail80TheTableorViewWasNotFoundintheDictionary81MixedLanguagesAreDisplayedWhenUsingSamples81UnabletoSelectMultipleReportFormatsWhenRunningaReport81AReportorAnalysisDoesNotRunBecauseofMissingItems81CannotViewBurstReport82Recursiveevaluationerror83ContentsvArithmeticOverflowErrorWhenRunningaReportinPDFFormat83RQP-DEF-0177Anerroroccurredwhileperformingoperation'sqlPrepareWithOptions'status='-69'UDA-SQL-0043Error83PCA-ERR-0087errorwhenyourunalargereport83MicrosoftExcelreportdoesnotopenwhenusingtheui.
backURLparameterwithMicrosoftInternetExplorer9.
x84Differencesintheappearanceofchartsthatarerunindifferentformatsorondifferentoperatingsystems.
.
.
84Out-of-memoryerrorswithreportsthatarerunininteractiveHTMLformat85Drill-throughlinksinactivereportsdonotwork85PerformanceProblemsWhenRunningReports86CGITimeoutErrorWhileTransferringDatatoIBMCognosAnalyticsComponents86TheBAP-ERR-0002BAPIError87TheOutofMemoryErrorAppearsinHP-UX87AQueryIsSlowWhenFilteringNon-ASCIIText87ReportOutputTakesaLongTimetoRun87Reportrunsslowly87ProblemsViewingReports89Anupgradedreportdoesnotretainitsoriginallook89PreventingfontchangesthatcausetextwrappinginPDFreportoutputs89MeasureFormatDisappearsinSSAS200590ARunningTotalinGroupedReportsGivesUnexpectedResults90ThePageCannotBeFoundErrorAppearsforReports90Non-EnglishCharactersAppearasPlaceholders91ChartsDoNotAppearinHTMLreports91CrosstabdisappearsinPowerPlayStudiowhenchangingthezoomlevelinIE892CognosStatisticsobjectisnotdisplayedinareport92PortalProblems92CannotConnecttoaSQLServerDatabaseUsinganODBCDriver93UnabletoClickLinks93MissingImagesinaPDFReport94ProblemsPrintingReports94ChartsinPDFOutputShowUnexpectedResults94APrintedHTMLReportisUnsatisfactory94UnderstandingDrill-ThroughResults.
94FiltersAreNotCorrectWhenUsersDrillThroughtoUpgradedTargetsinAnalysisStudio.
95Drill-throughLinksareNotActiveintheSafariBrowser96UnexpectedorEmptyResultsWhenDrillingThrough96CannotDrillThroughFromaRelationalSourcetoaCube.
97CannotDrillThroughBetweenPowerCubesBecauseMUNsDoNotMatch97DrillingThroughtoIBMCognosAnalyticsfromanIBMCognosSeries7ProductResultsinaFirewallError98DetailCellsareNotDisplayedforExcludedItemsWhenDrillingThroughtoPowerPlayStudio98Drill-ThroughParameterisIgnoredinPowerPlayStudioDuetoaCustomSet99Drill-ThroughDefinitionisNotAvailable99CalculationsDoNotAppearintheTargetReport.
99TargetReportDoesNotFilterProperlyWithout"Go-To"Parameters100EmptyCellsReturnedinaTargetReportwithExcludedItems100NestedCrosstabOnlyFiltersonSomeItems100DataDoesNotAppearinaTargetReportortheWrongDataAppears101DataisNotFilteredintheTargetReportAfterDrill-Through101Chapter7.
IBMCognosWorkspaceAdministrationProblems.
103SecureConnectionFailederrorwhenaccessingIBMConnections103ProblemssavingaworkspaceinIBMCognosWorkspace.
103Chapter8.
ProblemswhenusingIBMCognosAnalyticsonmobiledevices105Mobileserviceproblems.
105Chartsandimagesnotappearing.
105Listpromptitemsconsistingofonlyasinglespacearenotsupported105IBMCognosMobileserviceconfigurationsettingsareresettothedefaultsafterupgrading106AdvancedHTMLfunctionalityisnotsupported.
106viIBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidejava.
lang.
NoClassDefFoundError106java.
lang.
InternalError:Can'tconnecttoX11Windowsserverusing':0.
0'asthevalueoftheDISPLAYvariable106IBMCognosMobileservicestartsbutthenstops106CognosMobiledatabasetablesarenotcreated106Mobileclientproblems107Imagesdonotappearonmobiledevices107IBMCognosMobiledoesnotfilterdownstreampromptsforcascadingpromptsusingreprompt107Repeatertablesrenderincorrectly107CalendarpromptsshowonlytheGregoriancalendar107IBMCognosMobilefailstoconnecttoMicrosoftSQLServer107Longtextmessagesmaybetruncated108Noreportsavailablewhenloggedonfromthemobileclient108Somemobileusersdonotreceiveburstreports108Index109ContentsviiviiiIBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideChapter1.
TroubleshootaproblemTroubleshootingisasystematicapproachtosolvingaproblem.
Thegoaloftroubleshootingistodeterminewhysomethingdoesnotworkasexpectedandhowtoresolvetheproblem.
Reviewthefollowingtabletohelpyouorcustomersupportresolveaproblem.
Table1.
ActionsanddescriptionsActionsDescriptionAproductfixmightbeavailabletoresolveyourproblem.
Applyallknownfixpacks,orservicelevels,orprogramtemporaryfixes(PTF).
Ensurethattheconfigurationissupported.
ReviewtheinformationintheIBMSoftwareProductCompatibilityReportspage(www.
ibm.
com/support/docview.
wssuid=swg27047186).
LookuperrormessagesbyselectingtheproductfromtheIBMSupportPortal(www.
ibm.
com/support/entry/portal/support),andthentypingtheerrormessagecodeintotheSearchsupportboxontherightverticalmenubar.
Errormessagesgiveimportantinformationtohelpyouidentifythecomponentthatiscausingtheproblem.
Reproducetheproblemtoensurethatitisnotjustasimpleerror.
Ifsamplesareavailablewiththeproduct,youmighttrytoreproducetheproblembyusingthesampledata.
Ensurethattheinstallationsuccessfullyfinished.
Theinstallationlocationmustcontaintheappropriatefilestructureandthefilepermissions.
Forexample,iftheproductrequireswriteaccesstologfiles,ensurethatthedirectoryhasthecorrectpermission.
Reviewallrelevantdocumentation,includingreleasenotes,technotes,andprovenpracticesdocumentation.
SearchtheIBMknowledgebasestodeterminewhetheryourproblemisknown,hasaworkaround,orifitisalreadyresolvedanddocumented.
Formoreinformation,see"Knowledgebases"onpage2.
Reviewrecentchangesinyourcomputingenvironment.
Sometimesinstallingnewsoftwaremightcausecompatibilityissues.
Iftheitemsonthechecklistdidnotguideyoutoaresolution,youmightneedtocollectdiagnosticdata.
ThisdataisnecessaryforanIBMtechnical-supportrepresentativetoeffectivelytroubleshootandassistyouinresolvingtheproblem.
Youcanalsocollectdiagnosticdataandanalyzeityourself.
TroubleshootingresourcesTroubleshootingresourcesaresourcesofinformationthatcanhelpyouresolveaproblemthatyouarehavingwithanIBMCognosproduct.
Manyoftheresourcelinksprovidedinthissectioncanalsobeviewedinashortvideodemonstration.
1Toviewthevideoversion,searchfor"IBMCognostroubleshooting"througheitheranInternetsearchengineorYouTubevideocommunity.
IBMSupportPortalTheIBMSupportPortalisaunified,centralizedviewofalltechnicalsupporttoolsandinformationforallIBMsystems,software,andservices.
TheIBMSupportPortalletsyouaccessalltheIBMsupportresourcesfromoneplace.
Youcantailorthepagestofocusontheinformationandresourcesthatyouneedforproblempreventionandfasterproblemresolution.
BeforecontactingIBMSupport,youwillneedtocollectdiagnosticdata(systeminformation,symptoms,logfiles,traces,andsoon)thatisrequiredtoresolveaproblem.
Gatheringthisinformationwillhelptofamiliarizeyouwiththetroubleshootingprocessandsaveyoutime.
InformationonwhatdatatocollectisavailableintheformofMustGathertechnotes.
ProblemdeterminationSeveralIBMCognosproblemdeterminationtoolsareavailabletodiagnoseandtroubleshootcommonproblems.
ThesetoolscanbedownloadedfromtheCognosDiagnosticUtilitiespage.
IBMEducationAssistantprovidesvideoandothertrainingresourcesonsomeofthesediagnostictoolsontheEducationAssistantProblemDeterminationwebsite.
ServicerequestsServicerequestsarealsoknownasProblemManagementReports(PMRs).
SeveralmethodsexisttosubmitdiagnosticinformationtoIBMSoftwareTechnicalSupport.
ToopenaPMRortoexchangeinformationwithtechnicalsupport,viewtheIBMSoftwareSupportExchanginginformationwithTechnicalSupportpage.
PMRscanalsobesubmitteddirectlybyusingtheServicerequests(PMRs)tool,oroneoftheothersupportedmethodsdetailedontheexchanginginformationpage.
FixCentralFixCentralprovidesfixesandupdatesforyoursystem'ssoftware,hardware,andoperatingsystem.
Usethepull-downmenutonavigatetoyourproductfixesonFixCentral.
YoumayalsowanttoviewFixCentralhelp.
KnowledgebasesYoucanfindsolutionstoproblemsbysearchingIBMknowledgebases.
YoucanusetheIBMmastheadsearchbytypingyoursearchstringintotheSearchfieldatthetopofanyibm.
compage.
IBMKnowledgeCenterIBMKnowledgeCenterincludesdocumentationforeachreleaseofIBMCognosAnalytics.
Thisdocumentationisalsoavailablethroughproducthelpmenus.
IBMKnowledgeCenter(http://www.
ibm.
com/support/knowledgecenter)includesEnglishandtranslateddocumentation.
ExpandtheCognosentryinthe2IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidetableofcontentstoaccessthedocumentationfordifferentIBMCognosproductsandreleases.
TofindlinkstothelatestknownproblemsandAPARs,accesstheReleaseNotes.
IBMRedbooksIBMRedbooksaredevelopedandpublishedbyIBM'sInternationalTechnicalSupportOrganization,theITSO.
IBMRedbooksprovidein-depthguidanceaboutsuchtopicsasinstallationandconfigurationandsolutionimplementation.
ProvenPracticesdocumentationCreatedbyCognosexpertsfromcustomerexperiencesBusinessanalyticsprovenpractices,providesverifiedtechnicalinformationinspecifictechnologyenvironments.
Asatroubleshootingresource,Businessanalyticsprovenpracticesprovideseasyaccesstothetoptenmostpopularpractices,inadditiontovideosandotherinformation:CognosProvenPracticedocumentation.
SoftwaresupportandRSSfeedsIBMSoftwareSupportRSSfeedsareaquick,easy,andlightweightformatformonitoringnewcontentaddedtowebsites.
AfteryoudownloadanRSSreaderorbrowserplug-in,youcansubscribetoIBMproductfeedsatIBMSoftwareSupportRSSfeeds.
ForumsandcommunitiesIBMCognosproductforumsofferaplacetoshareideasandsolutionswithyourpeersintheIBMCognoscommunity.
ActiveCognosforumsareavailableatCognosforumsandcommunities.
LogFilesLogfilescanhelpyoutroubleshootproblemsbyrecordingtheactivitiesthattakeplacewhenyouworkwithaproduct.
OperationsperformedinIBMCognosAnalyticsarerecordedinvariouslogfilesfortrackingpurposes.
Forexample,ifyouexperiencedproblemsinstallingIBMCognosAnalytics,consultthetransferlogfiletolearnwhatactivitiestheinstallationwizardperformedwhiletransferringfiles.
Beforeyoubeginviewinglogfiles,ensurethattheycontaintheinformationthatyouneed.
UseIBMCognosAdministrationtosetthelevelofdetailtologforeachcategory.
UseIBMCognosConfigurationtospecifythesize,number,andlocationoflogfiles,andtoconfigurethepropertiesofthelogserver.
Whentroubleshooting,thefollowingfilescanassistyou:Chapter1.
Troubleshootaproblem3TransferlogfileThisfilerecordsthecomponentsyouinstalled,diskspaceinformation,theselectionsyoumadeinthetransferdialogs,andanyerrorstheinstallationwizardencounteredwhiletransferringcomponents.
Italsorecordstheactivitiesthattheinstallationwizardperformedwhiletransferringfiles.
Thetransferlogfileislocatedintheinstall_location\logsdirectory.
Thefilenameincludestheproductnameandtimestamp.
Thefollowingisanexampleofthefilenameformat:IBM_Cognos_Analytics_Install_04_21_2016_11_00_59.
logInstallationConfigurationlogfileThislogfilerecordsanyconfigurationactivitiesduringtheinstallation.
Forexample,itreportstheavailableportforthedispatcher.
Thetransfersummary-errorlogfileislocatedintheinstall_location\logsdirectory.
Itisnamedinstall_configuration.
logTheStartupConfigurationFileThisfilerecordsyourconfigurationchoiceseachtimeyousaveyourpropertysettings.
Thefilenameiscogstartup.
xml.
Ifyouareunabletosaveyourconfiguration,orarehavingproblemsyoucanreverttoapreviouslysavedconfigurationfile.
Thebackupconfigurationfilesarelocatedintheinstall_location/configurationdirectory.
Thefollowingisanexampleofthefilenameformatforbackupconfigurationfiles:cogstartup_200811231540.
xmlTheStartupConfigurationLockFileThisfileiscreatedeachtimeyouopenIBMCognosConfiguration.
ItpreventsyoufromopeningmorethanoneIBMCognosConfigurationwindow.
IfyouexperienceproblemsopeningIBMCognosConfiguration,youcanchecktheinstall_location/configurationdirectoryforthecogstartup.
lockfile.
IfthefileexistsandIBMCognosConfigurationisnotopen,itmeansthatIBMCognosConfigurationdidnotshutdownproperlythelasttimeyouusedit.
YoucandeletethelockfileandthenopenIBMCognosConfiguration.
TheLocaleConfigurationFileThisfilerecordstheconfigurationchoicesyoumakeinIBMCognosConfigurationforproductandcontentlocales,localemapping,andcurrencysupport.
Ifyouexperienceproblemswithlanguagesupportintheuserinterfaceorinreports,usethesefilestotrackyourchanges.
Thebackupconfigurationfilesarelocatedintheinstall_location/configurationdirectory.
Thefollowingisanexampleofthefilenameformat:coglocale_200811231540.
xml4IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideTheRuntimeLogFileThedefaultIBMCognoslogfile,namedcogaudit.
logfile,orotherlogfilesthatyouconfiguretoreceivelogmessagesfromthelogserver,recordinformationafteryoustarttheIBMCognosAnalyticsservice.
Theyarelocatedintheinstall_location/logsdirectory.
Ifyouconfiguredanotherdestinationforlogmessages,checktheappropriatefileordatabase.
Somelogmessagesindicateproblems.
Mostmessagesprovideinformationonly,butotherscanhelpyoutodiagnoseproblemsinyourruntimeenvironment.
TheGatewayLogFileThegatewaysrecorderrorsinthegatewaylogfile,whichislocatedintheinstall_location/logsdirectory.
Youcanusethegatewaylogfiletotroubleshootproblemsthatpreventthegatewayfromprocessingrequestsorfromusingencryption.
Symptomsoftheseproblemsareasfollows:vUserIDsandpasswordsdonotworkvSinglesignondoesnotworkvThedispatcherisrunningbutusersreceivesanerrormessageadvisingthattheIBMCognosAnalyticsserverisnotavailableThegatewaylogfileusesthefollowingnamingformat,wheregateway_interfaceiscgi,mod2(Apache2.
0module),orisapi.
gwgateway_interface.
log(forexample,gwcgi.
log)TheUninstallationLogFileThisfilerecordstheactivitiesthattheUninstallwizardperformedwhileuninstallingfiles.
Thelogfileisnamedcognos_uninst_log.
htmandislocatedintheTempdirectory.
YoucanusethelogfiletotroubleshootproblemsrelatedtouninstallingIBMCognosAnalyticscomponents.
TheSilentModeLogFileThisfilerecordstheactivitiesthatIBMCognosConfigurationperformedwhilerunninginsilentmode.
Thislogfileisnamedcogconfig_response.
csvandislocatedintheinstall_location/logsdirectory.
ErrorMessagesThefirstindicationofaproblemisoftenanerrormessage.
Errormessagescontaininformationthatcanbehelpfulindeterminingthecauseofaproblem.
YoucanclicktheDetailslinktoseethefullerrormessage.
Theadministratorcanusethisinformation,aswellasotherinformationaboutwhatproductyouareusingandwhatyoudidbeforetheerrormessagedisplayed,toresolveanissue.
IfyouclickOKinresponsetotheerrormessage,IBMCognosAnalyticsundoesthelastactionandreturnstothepreviousstate.
Chapter1.
Troubleshootaproblem5CoredumpfilesIfyoureceiveanerrormessageaboutthereportservernotresponding,IBMCognosAnalyticswroteacoredump(.
dmp)filetothefilesystem.
Coredumpfilesindicateaseriousproblemwiththeprogram,suchasanunhandledexceptionoranIBMCognosAnalyticsprocessthatterminatedabnormally.
Coredumpfilescreateacompletememorydumpofthecurrentstateoftheprogramwhentheproblemoccurs.
ThecorefileusuallyindicatesabugthatrequiresasoftwarefixIfyouseethereportservernotrespondingmessage,immediatelycheckthe\bindirectoryoftheIBMCognosAnalyticsserverinstallationforanycoredumpfiles.
OnWindows,thesefilesarenamedprocessID.
dmp,suchasBIBusTKServerMain_seh_3524_3208.
dmp.
OnUNIX,thefilesarenamedcore.
OnLinux,thefilesarenamedcore.
processID.
Thesebinaryfilesmustbeviewedwithadebuggingprogramsuchasdbx,GNUdebugger,ortheWinDbgdebuggerforWindows.
Ifyourserveradministratorcannotsolvetheproblem,contactIBMsupportandprovidethemwithatestcase,ifpossible,andthecorefiles.
Corefilescanbe300MBormore,andanewoneofthesamesizeiscreatedeachtimethattheproblemoccurs.
InWindows,thefilesshouldbecheckedandcleanedregularly,duringregularservermaintenance.
InUNIXandLinux,systemsettingscancontrolhowandwhenthecorefileiswrittentothefilesystemwhenaprocessabnormallyterminates.
InWindows,youcanuseaconfigurationfiletoturnoffthecreationof.
dmpfiles.
Inaproductionenvironment,youcanthenenablecoredumpswhenyouencounterproblems.
Becausenotallproblemsareeasytoreproduce,corefilecreationshouldbeenabledinyourtestinganddevelopmentenvironmentsothatyoucanusethem.
WithsomeIBMCognosAnalyticshotsitebuilds,coredumpfilesareautomaticallycreated.
Duringanupgrade,configurationsettingsarenotoverwritten.
TurnoffcorefilecreationYoucanturnoffcorefilecreation.
Procedure1.
OntheserverwhereIBMCognosAnalyticsisinstalled,openthecclWinSEHConfig.
xmlfilefromtheinstall_location\configurationdirectory.
2.
Intheconfigurationelement,changethevalueoftheenvironmentvariablesettingto0(zero)sothatitreads3.
Savethefile.
MetricDumpFileYoucanusethemetricdumpfiletoobtaindetailedinformationaboutthestateofthesystemataparticulartime,andtotracksystemtrendsoveragivenperiodoftimeforhistoricalpurposes.
6IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideThedefaultnameofthisfileismetricdump.
xmlanditislocatedintheinstall_location/logsdirectory.
Themetricdumpfilerecordsasnapshotofthecurrentsystemmetrics.
Thefiledoesnotappearintheinstall_location/logsdirectoryuntilmetricdumpingisenabledinIBMCognosAdministration.
Formoreinformation,see"EnableMetricDumpinginIBMCognosAdministration.
"Bydefault,metricdumpingisdisabled.
Theprocessofmetricdumpingisconfiguredusingthemetricdumpconfiguration.
xmlfileintheinstall_location/configurationdirectory.
Formoreinformation,see"Changethemetricdumpconfiguration.
xmlfile"onpage8.
Thisfileisusedtospecifytheresourcestobetrackedinthemetricdumpfile,andtocontrolthesizeandlocationofthemetricdumpfile.
AftermetricdumpingisenabledinIBMCognosAdministration,youcankeepitinactivebyrenamingthemetricdumpconfiguration.
xmlfile.
Toreactivatemetricdumpingforaparticularevent,renametheconfigurationfilebacktoitsoriginalname.
Note:Youcanrenamethemetricdump.
xmlfileandchangeitslocationusingthemetricdumpconfiguration.
xmlfile.
EnableMetricDumpinginIBMCognosAdministrationYoucanenablemetricdumpinginIBMCognosAdministration.
Procedure1.
OntheConfigurationtabinIBMCognosAdministration,clickDispatchersandServices.
2.
Fromthetoolbarintheupper-rightcornerofthepage,clickthesetpropertiesbutton.
TheSetproperties-Configurationpagedisplays.
3.
ClicktheSettingstab.
4.
FortheEnvironmentcategory,nexttoAdvancedsettings,intheValuecolumn,clickEdit.
5.
IntheSetadvancedsettingspage,intheParametercolumn,typethefollowingsetting:DISP.
MetricDumpEnabledTip:Thesettingnameiscase-sensitive.
6.
IntheValuecolumn,typetheURIofthedispatcher.
YoucanfindthedispatcherURIinIBMCognosConfiguration,underEnvironment>DispatcherSettings.
UseonlythefirstpartoftheURIthatendswith/p2pd.
Forexample,typehttp://install_server:9300/p2pd.
Tip:Todeletethissetting,clickthecheckboxnexttothesetting,clickDelete,andclickOKtwice.
7.
ClickOKtwice.
ResultsThefileconfiguration/metricdumpconfiguration.
xmliscreatedonthespecifieddispatcher.
Metricdumpfilesarethenautomaticallycreatedoneachdispatcherinadistributedinstallation.
Chapter1.
Troubleshootaproblem7Changethemetricdumpconfiguration.
xmlfileTheproceduretochangethemetricdumpconfiguration.
xmlfileisasfollows.
Procedure1.
Openthefileinstall_location\configuration\metricdumpconfiguration.
xmlinaneditor.
2.
Toconfiguretheresourcesforwhichmetricsaretobelogged,specifytheresourceinthefollowingsection:com.
cognos:type=Metrics,*com.
cognos:type=MetricHealth,*com.
cognos:type=ServiceHealth,*com.
cognos:type=ServiceOperationalStatus,*Forexample,tospecifyaservice,typecom.
cognos:type=Metrics,service=contentManagerService3.
Torenamethemetricdumpfileandchangethepath,editthefollowingline:.
.
/logs/metricdump.
xml4.
Tochangethetimeintervalfordumping,editthefollowingline:15000Thetimeisspecifiedinmilliseconds.
5.
TospecifywhethertoresettheMBeansafterthevaluesweredumped,editthefollowingline:falseChangingthevaluetotrueresetsmetricvaluesbackto0intheuserinterface.
Formoreinformation,seetheIBMCognosAnalyticsAdministrationandSecurityGuide.
6.
Tochangethemaximumnumberofdumps,editthefollowingline:-1-1meansunlimitednumberofdumps.
7.
Tochangethemaximumfilesizebeforerollover,editthefollowingline:100000008.
Tochangethenumberofmetricdumpfilestokeep,editthefollowingline:19.
Savethechanges.
MicrosoftWindowsEventViewerMicrosoftWindowsEventViewerprovidesinformationaboutprogram,security,andsystemevents.
Forexample,ifanIBMCognosAnalyticsservicefailstostart,thisfactisrecordedintheeventlog.
MicrosoftWindowsEventViewerdoesnotrecordinformationthatisspecifictooperationsortasksperformedinIBMCognosAnalytics.
ConsulttheIBMCognosAnalyticslogfilesfortheseproblems.
ForinformationabouthowtouseWindowsEventViewer,seetheWindowshelp.
SamplesIBMCognosAnalyticsusessamplestohighlightproductfeaturesandtohelpyoulearnhowtousetheproduct.
Youcanalsousesamplestotroubleshootproblems.
8IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideYoucanusethesamplesthatcomewithIBMCognosAnalyticstodetermineifvariouscomponentsareworkingtogetherasexpected.
Forexample,ifyouarehavingaproblemrunningareport,youcantryrunningasamplereporttoseeifproblempersists.
Youmaydiscoverthattheproblemisrelatedtoconnectingtoadatabase.
Chapter1.
Troubleshootaproblem910IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideChapter2.
InstallationandconfigurationproblemsYoumayencounterproblemsduringinstallationandconfiguration,orwhensettingupIBMCognosAnalyticstorunwithinanapplicationserver.
ProblemsstartingIBMCognosAnalyticsYoucanencounterproblemswhenstartingIBMCognosAnalytics.
Youmayencounterproblemswhenyoutrytoperformthefollowingtasks:vStarttheIBMCognosAnalyticsservice.
vOpentheWelcomepagefortheIBMCognosAnalyticsportalforthefirsttime.
vStartanapplicationserver,suchasWebSphere.
Thefollowingtableshowssomecommonsymptomsandtheirsolutions.
Table2.
SymptomsandsuggestedsolutionsforstartingIBMCognosAnalyticsSymptomsSolutionYoudonotseethesplashscreenfortheIBMCognosAnalyticsportalwhenyoustartIBMCognosAnalytics.
CheckyourWebserverconfiguration.
Theservicestarts,butnotablesarecreatedinthecontentstoredatabase.
Checkyourcontentstoreconfiguration.
Theservicedoesnotstart.
Ensurethatyouwaitafewmomentsbeforesubmittingarequest.
Theapplicationserverdoesnotstart.
Checkthefilepermissionsanddirectorynamesoftheapplicationserverinstallationlocation.
Toreviewanup-to-datelistofenvironmentsthataresupportedbyIBMCognosAnalyticsproducts,includinginformationonoperatingsystems,patches,browsers,webservers,directoryservers,databaseservers,andapplicationservers,seetheIBMSoftwareProductCompatibilityReportspage(www.
ibm.
com/support/docview.
wssuid=swg27047186).
CFG-ERR-0106errorwhenstartingtheIBMCognosserviceinIBMCognosConfigurationWhenyoustarttheIBMCognosAnalyticsservice,youmayreceivethefollowingerrormessage:CFG-ERR-0106IBMCognosConfigurationreceivednoresponsefromtheIBMCognosserviceintheallottedtime.
CheckthatIBMCognosserviceisavailableandproperlyconfigured.
Therearetwopossiblecausesforthisproblem:vTheIBMCognosserviceneedsmoretimetostart.
vAstandbyContentManagercomputermaybeconfiguredincorrectly.
11TheIBMCognosserviceneedsmoretimeBydefault,IBMCognosConfigurationcheckstheprogressofthestartrequesteveryhalfsecondforthreeminutes.
IfIBMCognosConfigurationdoesnotreceivearesponsewithinthistime,theerrormessagedisplays.
TheamountoftimethatIBMCognosConfigurationwaitstoreceivearesponsefromtheIBMCognosserviceiscontrolledbytheServiceWaitIntervalandServiceMaxTriesproperties.
TheServiceWaitIntervalpropertyrepresentsthetimeinterval,inmilliseconds,atwhichIBMCognosConfigurationcheckstheprogressofthestartrequest.
Bydefault,itsvalueis500,whichisequivalenttohalfasecond.
TheServiceMaxTriespropertyrepresentsthenumberoftimesthatIBMCognosConfigurationcheckstheprogressofthestartrequest.
Bydefault,itsvalueis360.
ContentManagerIsconfiguredincorrectlyIftheerrormessagedisplaysonastandbyContentManagercomputer,thesettingforstoringthesymmetrickeysmaybeincorrect.
ChangingthewaittimefortheIBMCognosserviceIfyoureceivedtheCFG-ERR-0106errorbecausetheIBMCognosserviceneedsmoretimetostart,changetheamountoftimethatIBMCognosConfigurationwaitstoreceivearesponsefromtheIBMCognosservice.
Bydefault,IBMCognosConfigurationcheckstheprogressofthestartrequesteveryhalfsecondforthreeminutes.
IfIBMCognosConfigurationdoesnotreceivearesponsewithinthistime,theerrormessageisdisplayed.
TheamountoftimethatIBMCognosConfigurationwaitstoreceivearesponsefromtheIBMCognosserviceiscontrolledbytheServiceWaitIntervalandServiceMaxTriesproperties.
TheServiceWaitIntervalpropertyrepresentsthetimeinterval,inmilliseconds,atwhichIBMCognosConfigurationcheckstheprogressofthestartrequest.
Bydefault,itsvalueis500,whichisequivalenttohalfasecond.
TheServiceMaxTriespropertyrepresentsthenumberoftimesthatIBMCognosConfigurationcheckstheprogressofthestartrequest.
Bydefault,itsvalueis360.
Procedure1.
UsingIBMCognosConfiguration,stoptheIBMCognosservice.
2.
Opentheinstall_location/configuration/cogconfig.
prefsfileinaneditor.
ThisfileiscreatedautomaticallythefirsttimeyouopenIBMCognosConfiguration.
3.
Addthefollowingcodetothefile:ServiceWaitInterval=numberofmillisecondsServiceMaxTries=numberoftimesTip:Addthenumericvaluesthatcorrespondtoyourconfigurationneeds.
4.
Savethefile.
5.
UsingIBMCognosConfiguration,starttheIBMCognosservice.
12IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideChangingthelocationwheresymmetrickeysarestoredIfyoureceivedtheCFG-ERR-0106erroronastandbyContentManagercomputer,configurethecomputertostorethesymmetrickeyslocally.
Thesettingforstoringthesymmetrickeysmaybeincorrect.
Procedure1.
OnthestandbyContentManagercomputer,startIBMCognosConfiguration.
2.
IntheExplorerwindow,underSecurity,clickCryptography.
3.
InthePropertieswindow,underCSKsettings,setStoresymmetrickeylocallytoTrue.
4.
FromtheFilemenu,clickSave.
5.
FromtheActionsmenu,clickStart.
Thisactionstartsallinstalledservicesthatarenotrunning.
Ifyouwanttostartaparticularservice,selecttheservicenodeintheExplorerwindowandthenclickStartfromtheActionsmenu.
CryptographicerrorwhenstartingIBMCognosAnalyticsIfthefollowingerroroccurswhenyoutrytostarttheIBMCognosAnalyticsserviceafterinstallingserverorclientcomponents,thenyourJavaRuntimeEnvironment(JRE)ismissingtheencryptionanddecryptionroutines.
Ifyoureceivethiserror,thenyoumustcopytheJavaArchive(.
jar)filethatisprovidedtoyourJREdirectorsinceitisrequiredbyIBMCognosAnalytics.
[Cryptography]1.
[ERROR]java.
lang.
NoClassDefFoundError:javax/net/ServerSocketFactory:YourJavaRuntimeEnvironment(JRE)ismissingtheencryptionanddecryptionroutinesthatarerequiredbyIBMCognosAnalytics.
YoumustcopytheJavaArchive(.
jar)filethatisprovidedtoyourJREdirectory.
ProcedureCopybcprov-jdkversion.
jarfromtheinstall_location/bin/jre/version/lib/extdirectorytotheJRE_location/lib/extdirectory.
Ifyouareusing64-bitcomponents,copythefilesfrominstall_location/bin64.
UnabletostarttheIBMCognosservicebecausetheportisusedbyanotherprocessYoumaynotbeabletostarttheIBMCognosAnalyticsserviceorprocessifoneofthedefaultportsisusedbyanotherprocess.
Tip:ToviewthecurrentnetworkTCP/IPnetworkconnections,usethenetstatcommand.
UseIBMCognosConfigurationtochangethedefaultportthatIBMCognosAnalyticsuses.
Whenyouchangetheportusedbythelocaldispatcher,youmustchangethevalueoftheDispatcherURIproperties.
BecausethechangeaffectsalltheURIsthatarebasedonthelocaldispatcher,youmustchangetheURIsofalllocalcomponents.
Bydefault,localcomponentscontainlocalhostintheURI.
Chapter2.
Installationandconfigurationproblems13Forexample,ifyouinstallallcomponentsononecomputerandyouwanttochangethedispatcherport,replace9300inalldispatcherandContentManagerURIswiththenewportnumber.
Procedure1.
StartIBMCognosConfiguration.
2.
IntheExplorerwindow,clicktheappropriategrouporcomponent:vToaccesstheportnumberinthedispatcherandContentManagerURIs,clickEnvironment.
vToaccesstheportnumberforthelocallogserver,underEnvironment,clickLogging.
vToaccesstheshutdownportnumber,underEnvironment,clickIBMCognosservices>IBMCognosAnalytics.
vToaccesstheportnumberforthelocationoftheapplications.
xmlfileusedbyPortalServices,underEnvironment,clickPortalServices.
3.
InthePropertieswindow,clicktheValueboxnexttothepropertythatyouwanttochange.
4.
Changethevaluefrom9300tothenewvalue.
EnsurethatyouchangetheportsinallURIsthatcontainlocalhost:9300.
5.
FromtheFilemenu,clickSave.
6.
FromtheActionmenu,clickStart.
IBMCognosservicedoesnotstartorfailsafterstartingYoustarttheIBMCognosAnalyticsservicebutserviceseitherdonotstartcorrectlyorareveryslowtostart.
Afterservicesstart,thesystemfailsashorttimeafterwards.
Whileservicesarestarting,Javauses100percentoftheCPUtime.
Youmayalsoreceivemultipleoccurrencesoferrormessagessuchasthefollowing:vDPR-DPR-1035Dispatcherdetectedanerror.
vCAM-CRP-1157UnabletosynchronizethelocalcommonsymmetrickeystorewithContentManager.
ProcedureIfyouuseaDB2databaseforthecontentstore,ensurethatthedatabaseversionandJavaversionarecompatible.
ForDb2version8.
2,Java1.
5isnotsupported.
ForDb2version9,Java1.
5issupportedonalloperatingsystemsexceptSolaris.
IBMCognosAnalyticsserverfailstostartandgivesnoerrormessageAnIBMCognosAnalyticsservermayfailtostartafteranupgradeornewinstallation,butnoerrormessagedisplays.
ThismayoccurwhenapreviouslyrunningornewIBMCognosAnalyticsserverisconfiguredtousealargeamountofmemory.
IftheserveronwhichIBMCognosAnalyticsisinstalledcontainsversion1.
0ofMicrosoftsecurityupdate921883,theremaybeanissuewhenalotofcontiguousmemoryisrequestedbyanapplication.
14IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideThisisaknownissuewithversion1.
0ofMicrosoftsecuritypatch921883.
Microsoftdistributedasecondversionofthepatchtofixtheproblem.
Asaworkaround,uninstallthefirstsecuritypatch,orinstallversion2.
0ofthepatch.
Alternatively,youcanconfiguretheIBMCognosAnalyticsservertouselessmemory.
Formoreinformation,seetheMicrosoftknowledgebasearticleaboutprogramsusingalotofcontiguousmemoryfailing,attheMicrosoftsupportWebsite.
ServernotavailablewhenstartingIBMCognosAnalyticsAfteryouconfigureIBMCognoscomponentsandstarttheIBMCognosservices,whenyouconnecttotheIBMCognosAnalyticsportal,thefollowingerrormessagemaydisplay:TheCognosGatewayisunabletoconnecttotheCognosAnalyticsserver.
Theservermaybeunavailable,orthegatewaymaynotbecorrectlyconfigured.
ChecktheIBMCognosserverlogfileformoreinformation.
Bydefault,thecogaudit.
logfileislocatedintheinstall_location/logsdirectory.
Ifyouconfiguredanotherdestinationforlogmessages,checktheappropriatefileordatabase.
ContentManagermaynotbeabletoconnecttothecontentstoreifthecontentstoreisnotconfiguredproperly.
ThismayoccurifvthecontentstoreusesanunsupportedcharacterencodingvthecontentstoreusesadatabasecollationsequencethatiscasesensitivevtheconfigurationsettingsyouspecifiedinIBMCognosConfigurationarenotvalidUnsupportedcharacterencodingIfthefollowingmessagesdisplayinthelogfile,thedatabaseyoucreatedforthecontentstoredoesnotuseasupportedcharacterencoding:vForOracle:CM-CFG-5063AContentManagerconfigurationerrorwasdetectedwhileconnectingtothecontentstore.
CM-SYS-5121ContentManagercannotstartbecausethedatabasecharactersetforthecontentstoreisnotsupported.
CM-SYS-5126ThecontentstoredatabaseserverusesthecharactersetUS7ASCII.
CM-SYS-5125ThecontentstoredatabaseclientusesthecharactersetUS7ASCII.
vForDb2UDB:CM-CFG-5063AContentManagerconfigurationerrorwasdetectedwhileconnectingtothecontentstore.
CM-SYS-5121ContentManagercannotstartbecausethedatabasecharactersetforthecontentstoreisnotsupported.
CM-SYS-5124Thecontentstoredatabaseserverusesthecodepage1252.
vForSybase:CM-CFG-5063AContentManagerconfigurationerrorwasdetectedwhileconnectingtothecontentstore.
CM-SYS-5121ContentManagercannotstartbecausethedatabasecharactersetforthecontentstoreisnotsupported.
Chapter2.
Installationandconfigurationproblems15ForContentManagertoconnecttothecontentstore,thecontentstoremustusetheappropriatecharacterencoding,aslistedinthefollowingtable.
Table3.
CharacterencodingusedbythecontentstoretoconnecttoaspecificdatabasetypeDatabaseCharacterencodingOracle9iAL32UTF8AL32UTF16Db2UDBCodesetUTF-8SybaseASEUTF-8MicrosoftSQLServerUTF8UTF16Toresolvethisproblem,youmustrecreatethecontentstoredatabaseusingthecorrectcharacterencoding,orconvertthecharacterencoding.
Formoreinformation,seethedatabasedocumentation.
Case-sensitivecollationsequenceIfthefollowingmessagesareinthelogfile,thedatabaseyoucreatedforthecontentstoreusesadatabasecollationsequencethatiscasesensitive:CM-CFG-5063AContentManagerconfigurationerrorwasdetectedwhileconnectingtothecontentstore.
CM-SYS-5122Thecontentstoredatabasehasadefaultcollationthatiscase-sensitive.
ContentManagerrequiresacontentstorethathasacase-insensitivecollation.
CM-SYS-5123Thecontentstoredatabaseserverusesthecollation.
CM-SYS-5007ContentManagerbuild@cm_build_version@failedtostart!
ReviewtheContentManagerlogfilesandthencontactyoursystemadministratororcustomersupport.
Toresolvethisproblem,youmustrecreatethecontentstoredatabaseusingadatabasecollationsequencethatisnotcasesensitive.
Formoreinformation,seethedatabasedocumentation.
InvalidconfigurationsettingsIfthefollowingorsimilarmessagesareinthelogfile,youdidnotconfigurethecontentstorecorrectlyinIBMCognosConfiguration.
vForMicrosoftSQLServer:CM-CFG-5063AContentManagerconfigurationerrorwasdetectedwhileconnectingtothecontentstore.
CM-CFG-5036ContentManagerfailedtoconnecttothecontentstore.
Theconnectionstringis"jdbc:JSQLConnect://localhost:1433/cm".
16IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideFailedLogon:com.
jnetdirect.
jsql.
x:Cannotopendatabaserequestedinlogin'cm'.
Loginfails.
url:jdbc:JSQLConnect://localhost:1433/cm.
vForDb2:CM-CFG-5063AContentManagerconfigurationerrorwasdetectedwhileconnectingtothecontentstore.
CM-SYS-5003ContentManagerisunabletoaccessthecontentstore.
Verifyyourdatabaseconnectionparametersandthencontactyourdatabaseadministrator.
[IBM][CLIDriver]SQL1013NThedatabasealiasnameordatabasename"CM123"couldnotbefound.
vForOracle:CM-CFG-5063AContentManagerconfigurationerrorwasdetectedwhileconnectingtothecontentstore.
CM-CFG-5036ContentManagerfailedtoconnecttothecontentstore.
Theconnectionstringis"jdbc:oracle:thin:@localhost:1521:pb1".
ORA-01017:invalidusername/password;logondenied.
vForSybase:CM-CFG-5063AContentManagerconfigurationerrorwasdetectedwhileconnectingtothecontentstore.
CM-CFG-5036ContentManagerfailedtoconnecttothecontentstore.
Theconnectionstringis"jdbc:sybase:Tds:localhost:5000/cm".
JZ006:CaughtIOException:java.
net.
ConnectException:Connectionrefused:connect.
IfyouareusinganOracledatabase,donotuseillegalcharacters,suchasanunderscoreinIBMCognosConfigurationfortheServiceNameproperty.
IftheServiceNameincludesillegalcharacters,tablesarenotcreatedinthecontentstoredatabasewhentheIBMCognosserviceisstarted.
ConfiguringaMicrosoftSQLServer,Oracle,Db2,Informix,orSybasecontentstoreinIBMCognosConfigurationIfyoureceivedaCM-CFG-5036orCM-CFG-5063errorcode,thecontentstoremightnotbeconfiguredcorrectly.
Toresolvetheissue,reconfigurethecontentstore.
Procedure1.
IntheExplorerwindow,gotoDataAccess>ContentManager.
Right-clickContentStore,andclickDelete.
Thedefaultcontentstoreisdeleted.
ContentManagermustbeconfiguredtoaccessonlyonecontentstore.
2.
Right-clickContentManager,andthenclickNewresource>Database.
3.
IntheNamebox,typeanameforthedatabase.
4.
IntheTypebox,selectthetypeofdatabase,andclickOK.
Tip:IfyouwanttouseOracleNet8keyword-valuepairtomanagethedatabaseconnection,selectOracledatabase(Advanced).
5.
InthePropertieswindow,providevaluesdependingonyourdatabasetype:vIfyouuseaMicrosoftSQLServerdatabase,typetheappropriatevaluesfortheDatabaseserverwithportnumberorinstancenameandDatabasenameproperties.
FortheDatabaseserverwithportnumberorinstancenameproperty,includetheportnumberifyouusenondefaultports.
IncludetheinstancenameiftherearemultipleinstancesofMicrosoftSQLServer.
Chapter2.
Installationandconfigurationproblems17Toconnecttoanamedinstance,youmustspecifytheinstancenameasaJavaDatabaseConnectivity(JDBC)URLpropertyoradatasourceproperty.
Forexample,youcantypelocalhost\instance1.
Ifnoinstancenamepropertyisspecified,aconnectiontothedefaultinstanceiscreated.
Thepropertiesspecifiedforthenamedinstance,alongwiththeuserIDandpassword,anddatabasename,areusedtocreateaJDBCURL.
Hereisanexample:jdbc:JSQLConnect://localhost\\instance1/user=sa/morepropertiesasrequiredvIfyouuseaDb2database,fortheDatabasenameproperty,typethedatabasealias.
vIfyouuseanOracledatabase,typetheappropriatevaluesfortheDatabaseserverandportnumberandServicenameproperties.
vIfyouuseanadvancedOracledatabase,fortheDatabasespecifierproperty,typetheOracleNet8keyword-valuepairfortheconnection.
Hereisanexample:(description=(address=(host=myhost)(protocol=tcp)(port=1521)(connect_data=(sid=(orcl)))))vIfyouuseaSybasedatabase,typetheappropriatevaluesfortheDatabaseserverandportnumberandDatabasenameproperties.
6.
Ifyouwanttochangethelogoncredentials,specifyauserIDandpasswordinthefollowingway:vClicktheValueboxnexttotheUserIDandpasswordpropertyandthenclicktheediticonwhenitisdisplayed.
vTypetheappropriatevaluesandclickOK.
7.
FromtheFilemenu,clickSave.
Thelogoncredentialsareimmediatelyencrypted.
CannotlogontoanamespaceErrordisplayedwhenyouattempttocreateadatasourceandlogontoanamespace.
vPRS-CSE-1255Exceptionerrorencounteredindatadecryption.
vCAM-CRP-1064UnabletoprocessthePKCS#7databecauseofaninternalerror.
Reason:java.
lang.
IndexOutOfBoundsException.
Thisissuemightoccurifyoudonothavethenecessarypermissionsforthefollowingdirectories:vinstall_location\configurationvinstall_location\configuration\cskvinstall_location\configuration\encryptkeypairvinstall_location\configuration\signkeypairEnablethereadandexecutepermissionsonthedirectorieslistedaboveforanyonewhomuststarttheIBMCognosservice.
IBMCognosservicesfailtorestartafteranetworkoutageTheIBMCognosBootstrapServicerestartsIBMCognosservicesafteranetworkoutage.
ForinstallationswhereyouusethedefaultWebSphereApplicationServerLibertyProfileandwhereanetworkIPaddressisspecifiedintheinternaldispatcherURI,18IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidetheIBMCognosservicesmightnotinitializesuccessfullyduringtherestart.
Inthiscase,manuallyrestarttheservicesafterthenetworkisrestored.
ProcedureToresolvetheproblem,configuretheInternaldispatcherURIpropertyinIBMCognosConfigurationtouselocalhostorthenetworkhostname.
NowarningthatinstallingalaterversionwillautomaticallyupdatetheearlierversionofthecontentstoreYouhaveaversionIBMCognosBusinessIntelligenceinstalled.
YouinstallIBMCognosAnalyticsintoanewlocation.
Youusethesamedatabaseforthecontentstoreforbothversions.
AfteryouconfigurethelaterversionandstarttheIBMCognosservice,theearlierversionofIBMCognosBusinessIntelligencenolongerworksbecauseallcontentisautomaticallyupgraded.
IfyouwanttouseboththeearlierversionofIBMCognosBusinessIntelligenceandIBMCognosAnalyticsafteryouupgrade,ensurethatbeforeyouinstallthelaterversion,youvbackupthedatabaseyouuseforthecontentstorevrestorethebackuptoanewlocationAlternatively,youcanchoosetousethedeploymenttooltoimporttheentirecontentstorefromanearlierversiontothelaterversion.
Allexistingcontentinthecontentstoredatabaseisreplacedbytheimportedcontent.
Youreceiveawarningmessageaboutthis.
DownloadofresourcefailsIfthedownloadresourcefails,itmaybecausedbyrecentMicrosoftXMLHTTPupgradesifyoudonothavealanguagepreferencesetinInternetExplorer.
YoustartReportinginInternetExplorerandthefollowingerrormessagedisplays:Thedownloadofthespecifiedresourcehasfailed.
ProcedureToresolvetheproblem,specifyalanguagepreferenceinInternetExplorer.
Db2returnsSQL1224NerrorwhenconnectingfromAIXIfyourcontentstoreisaDb2databaseandyoureceiveanSQL1224NerroronAIX,checkthedb2diag.
logfileforadditionalinformationabouttheerror.
Iftheerrorincludesreasoncode18,youmightneedtochangetheDb2configurationtoacceptmoreconnections.
Formoreinformation,seetheIBMDb2supportpagesfortheerrorSQL1224N.
ContentManagererrorwhenstartingIBMCognosAnalyticsAfterstartingIBMCognosAnalytics,noBIBUSTKSERVMAprocessisstarted.
Thereareerrorslistedinthepogo******.
logandcogaudit.
logfiles.
UsersreceiveerrorsinthebrowserwhenconnectingtotheIBMCognosAnalyticsportal.
Inthepogo******.
logfile,anerrorrelatedtoContentManagerdisplays.
Chapter2.
Installationandconfigurationproblems19Inthecogaudit.
logfile,thefollowingerrordisplays:AnattempttoregisterthedispatcherinContentManagerwasunsuccessful.
Willretryperiodically.
Whenconnectingtohttp://computername/ibmcognos,thefollowingerrormessagesdisplayinthebrowser:vDPR-ERR-2058Thedispatchercannotservicetherequestatthistime.
ThedispatcherisstillinitializingvSoapSocketException:ConnectionRefusedIBMCognosConfigurationusesauserIDtobindtotheLDAPdatabase.
IfthisuserIDismovedtoanothergroup,IBMCognosConfigurationcannolongerlocateit.
ProcedureTocorrecttheproblem,movetheuserIDbacktotheoriginalgroup.
ContentManagerfailstostartortakesalongtimetostartOnMicrosoftWindows,youtrytostarttheserviceonthecomputerwhereyouinstalledContentManager.
Astheserviceisstarting,thedetailsincludeerrorssimilartothefollowing:DPR-CMI-4006UnabletodeterminetheactiveContentManager.
Willretryperiodically.
CM-SYS-5007ContentManagerbuildx.
x.
x.
xfailedtostart!
DetailswithintheerrorlogmayalsoincludereferencestoOutOfMemoryError.
Toresolvethisproblem,starttheserviceusingtheDuseCMLargeResultSetparameter.
YoucanaddtheparametertothebootstrapconfigurationfileandthenstarttheserviceusingIBMCognosConfigurationoryoucanaddtheparametertothestartupconfigurationfileandthenrunthefile.
Resolvinganout-of-memoryerrorusingthebootstrapconfigurationfileStarttheIBMCognosservicebyaddingtheDuseCMLargeResultSetparametertothebootstrapconfigurationfile.
Procedure1.
Gototheinstall_location\bindirectoryandopenbootstrap_wlp.
xmlinanXMLeditor.
2.
Findthesectionthatbeginswith"${install_path}.
3.
UncommenttheDuseCMLargeResultSetparametertothatsection,inthelocationshownbytheboldtextinthefollowingexample.
"-Dcatalina.
base=${install_path}/tomcat""-Dcatalina.
home=${install_path}/tomcat""-Djava.
io.
tmpdir=${temp}""-DuseCMLargeResultSet=true"4.
Saveandclosethefile.
5.
StartIBMCognosConfigurationandstarttheservice.
20IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideResolvinganout-of-memoryerrorusingthestartupconfigurationfileStarttheIBMCognosservicebyaddingtheDuseCMLargeResultSetparametertothestartupconfigurationfile.
Procedure1.
Gototheinstall_location\bindirectoryandopenstartup.
batinatexteditor.
2.
Findthefollowingline:setCATALINA_OPTS=-Xmx768m-XX:MaxNewSize=384m-XX:NewSize=192m-XX:MaxPermSize=128m%DEBUG_OPTS%3.
AppendtheDuseCMLargeResultSetparametertotheline,asshownbytheboldtextinthefollowingexample:setCATALINA_OPTS=-Xmx768m-XX:MaxNewSize=384m-XX:NewSize=192m-XX:MaxPermSize=128m%DEBUG_OPTS%-DuseCMLargeResultSet=true4.
Saveandclosethefile.
5.
Starttheservicebyrunningthestartup.
batfile.
ManagingtheConfigurationServerTheconfigurationserveridentifiestheserverthatmanagesconfigurationvalues.
Thisiscriticalinmulti-serverinstallationssothatconfigurationvaluesremainavailableandconsistentonallnodes,evenafternetworkpartitions.
Theconfigurationserverrunsonthesameinstanceastheactivecontentmanager.
Appliesto(replacedinbyConfigurationGroup).
AboutthistaskInEasyinstallations,andifyouareexpandingthecapacityofarunningsystembyselectingtheConnectandinstalloption,thisvalueissetforyou.
Procedure1.
StartCognosConfiguration.
2.
IntheExplorerwindow,underLocalConfiguration,clickEnvironment.
3.
IntheEnvironment-GroupPropertieswindow,scrolldowntothecategoryOtherURISettings,andclickConfigurationServer.
4.
Tosetthecorrectvalue:vIfthisistheactiveContentManagerserverinstallation,youcansetthevaluetothelocalserverbyright-clickingandthenclickingResettoDefault.
vIfthisisthestandbyContentManagerserverinstall,oranApplicationtierinstall,youneedtosetthevaluebyclickingontheediticontolaunchtheeditdialog.
a.
InValue-ConfigurationServerdialog,clickontheRetrievebuttontolaunchRetrieveConfigurationServersdialog.
EntertheproperinformationtoaccesstheactiveContentManagerserver,andthenclickOK.
UserID-TheIDwithadministrationprivilegesontheserver.
Password-ThepasswordfortheUserID.
Chapter2.
Installationandconfigurationproblems21NamespaceID-ThevaluecanbefoundintheSecurity,Authenticationresource.
Forexample,CognosExCognosAnalyticsURL-TheURLusedtorunCognosAnalytics.
Forexample,http://myserver:9300/bib.
TheConfigurationServervalueisretrieved.
ClickOKtosetthevalue.
vIfyoucannotretrievethevalueusingtheRetrievebutton,youcansetthevaluemanually.
a.
OntheactiveContentManagerserver,openinstall_location/zookeeper/conf/zoo.
cfgb.
Findtwosettingslikethis:server.
1=Myhost.
ibm.
com:2888:3888clientPort=2181c.
Concatenatethetwovaluewithasemicolonlikethis:Myhost.
ibm.
com:2888:3888;2181d.
Enterthatvalueintheproperty.
5.
Savetheconfiguration.
DPR-ERR-2014errorinthelogfileontheContentManagercomputerThiserrorisdisplayedifContentManagerisinstalledonaseparatecomputerandtheeventmanagementserviceontheContentManagercomputerisenabled,orifyouhaveasingle-serverinstallationandtheeventmanagementserviceisdisabled.
Thefollowingerrormessagemightbedisplayedinthecogaudit.
logfile:DPR-ERR-2014Unabletoloadbalancetherequestbecausenonodesintheclusterareavailable,ornonodesareconfiguredfortheservice:eventManagementServiceTocorrecttheproblem,turnofftheeventmanagementserviceinadistributedinstallationwithContentManageronaseparatecomputer,orenabletheserviceinasingle-serverinstallation.
Procedure1.
Dooneofthefollowingsteps:vInadistributedinstallationwithContentManageronaseparatecomputer,startIBMCognosConfigurationontheContentManagercomputer.
vInasingle-serverinstallation,startIBMCognosConfiguration.
2.
IntheExplorerpane,gotoEnvironment>IBMCognosservices.
3.
Dooneofthefollowingsteps:vForadistributedinstallation,settheEventmanagementserviceenabledpropertytoFalse.
vForasingle-serverinstallation,settheEventmanagementserviceenabledpropertytoTrue.
4.
Saveyourchanges.
5.
Restarttheservices.
22IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideNon-ASCIIcharactersininstallationdirectorycauserun-timeerrorsOnalloperatingsystems,ifyouusenon-ASCIIcharactersintheinstallationdirectoryforIBMCognosAnalytics,itcausesrun-timeerrors.
Italsocausessomeproductfunctions,suchasreportexecution,tofail.
InstallIBMCognosAnalyticsinthedefaultdirectoryoruseadirectorynamethatcontainsonlyASCIILatin-1characters.
CannotOpenaMicrosoftCubeorPowerCubeYouareunabletoopenaMicrosoftCubeorPowerCube,oryoucanopenanMicrosoftCubebutonlymetadataisshown.
ForanMicrosoftCube,youmayreceivethefollowingerrormessage:MO-ERR-0030Cannotconnecttothedatasource.
Pleasesettheservicetorunasadomainuserwiththecorrectprivileges.
Tosolvethisproblem,ensurethattheuserrunningtheIBMCognosAnalyticsservicehasaccessrightstothecube.
PowerCubesareaccessedthroughmappeddrivesorUNCpathnames.
AssigningaccessrightstoMicrosoftcubesForauseraccounttoopenMicrosoftcubes,itmustbeassignedtheappropriateprivilegesinthesystemadministrativetools.
Procedure1.
AddthedomainuseraccountthatstartstheIBMCognosservicetotheActaspartoftheoperatingsystemprivilege:vUnderAdministrativeTools,selectLocalSecurityPolicy.
vExpandSecuritySettings,LocalPoliciesandclickUserRightsAssignment.
vRight-clicktheActaspartoftheoperatingsystempolicyandselectProperties.
vClickAddUserorGroupandaddtheuseraccountthatstartstheIBMCognosservice.
2.
IfyouusethedomainuserIDandpasswordmethodofauthentication,addtheuseraccountthatstartstheIBMCognosservicetothedomainthatincludesContentManager,theApplicationTierComponents,IISWebserver,andthedatasourceserver(MicrosoftSQLServerorMicrosoftAnalysisServer).
3.
Ifyouuseanexternalnamespace,suchasActiveDirectoryServer,forauthentication,addtheuseraccountthatstartstheIBMCognosservicetothedomainthatincludestheauthenticationprovider.
ThisdomainmustalsoincludeContentManager,theApplicationTierComponents,IISWebserver,andthedatasourceserver(MicrosoftSQLServerorMicrosoftAnalysisServer).
Formoreinformationaboutconfiguringexternalnamespacesforauthentication,seethetopicsaboutauthenticationprovidersintheIBMCognosAnalyticsInstallationandConfigurationGuide.
Chapter2.
Installationandconfigurationproblems23AssigningaccessrightstoPowerCubesForauseraccounttoopenPowerCubes,itmustbeassignedtheappropriateprivilegesinIBMCognosAdministration.
ProcedureEnsurethattheIBMCognosuserprofilehassufficientoperatingsystemordomainaccessrightstoopenthePowerCubefile.
ThepageisnotshownwhenopeningaportalafterinstallingIBMCognosAnalyticsAfteryouinstallandconfigureIBMCognosAnalytics,youareunabletoconnecttotheCognosAnalyticsportal.
ThismaybebecausetheWebserverisnotproperlyconfigured.
Forexample,thevirtualdirectoriesrequiredforIBMCognosAnalyticsmaynotexistortheymaypointtothewrongphysicalfolders.
ForinformationaboutconfiguringtheWebserver,seetheIBMCognosAnalyticsInstallationandConfigurationGuide.
DPR-ERR-2058ErrorDisplaysinWebBrowserWhenStartingIBMCognosAnalyticsAfteryoustarttheservicesinIBMCognosConfigurationandthentrytoopentheportal,amessagesimilartooneofthefollowingmaydisplay:DPR-ERR-2058Thedispatcherencounteredanerrorwhileservicingarequest.
XTShandlermustbeinitializedbeforebeinginvoked.
DPR-ERR-2058Thedispatchercannotservicetherequestatthistime.
Thedispatcherisstillinitializing.
Pleasetryagainorcontactyouradministrator.
TheseerrormessagesusuallyoccurwhenthedispatchercannotcommunicatewiththeContentManager.
Tohelpyoudeterminethespecificcause,lookinthecogaudit.
logfileintheinstall_location/logsdirectory.
Thefollowingarethemostcommoncauseswiththeirsolutions.
IBMCognosServicesareNotDoneInitializingAfteryoustarttheservicesinIBMCognosConfigurationandtheconfigurationtoolshowsthattheservicesarerunning,waitafewminutesforallservicestostartbeforeyouopentheportal.
ContentManagerisNotAvailableInadistributedinstallation,ensurethatContentManagerisinstalled,configured,andrunning.
EnsurealsothattheotherIBMCognoscomputersareconfiguredwiththecorrectContentManagerURI.
TheContentStoreisNotAvailableorisNotConfiguredProperlyEnsurethatthecontentstoredatabasewascreatedandthatyouconfigureditcorrectlyinIBMCognosConfiguration.
TablesareNotCreatedintheContentStoreEnsurethatyouareusingaversionofDb2,MicrosoftSQLServer,Oracle,orSybasethatissupportedbyIBMCognoscomponents.
24IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideTheLogonCredentialsfortheContentStoreAreIncorrectCheckwhethertheinformationchanged.
Forexample,Db2readsinformationfromtheNTusermanagement.
IfthepasswordfortheNTaccountchanged,youmustalsochangethelogoncredentialsforthecontentstoreinIBMCognosConfiguration.
Checkforspecialcharactersinthelogonpassword.
Occasionally,theJDBCdriverdoesnotacceptcharactersthatarereservedforxml,suchasand>.
TheUserDoesnotHaveAppropriatePermissionsEnsurethattheuserhastheappropriatepermissions.
OutofmemoryonHP-UXIfyouareusingtheapplicationserverthatisprovidedwithIBMCognosAnalytics,youcandeterminetheissueisrelatedtoHP-UXserverconfiguration.
Youmightbeexceedingtheexpectedmaximumnumberofsimultaneouslyactivethreadsperprocess.
IncreasingthemaximumnumberofthreadsperprocessonHP-UX:IfyouareexceedingtheexpectedmaximumnumberofsimultaneouslyactivethreadsperprocessonHP-UX,increasethenumberofactivethreads.
ProcedureHaveyoursystemadministratorchangetheKernelparameterasfollows:vmax_thread_proc=512vnkthread=1024CheckingforanHP-UXconfigurationproblem:Ifincreasingthemaximumnumberofactivethreadsperprocessdoesnotresolvetheout-of-memoryerroronHP-UX,performthefollowingsteps.
Procedure1.
Inthe/bin/startup.
shfile,find.
.
/tomcat/bin/catalina.
shstart"$@"2.
Changeittothefollowing:.
.
/tomcat/bin/catalina.
shrun"$@"TheruncommandcausestheTomcatoutputtodisplayintheconsolewindowforIBMCognosAnalytics.
3.
StopandrestartIBMCognosAnalyticsusingthe.
/shutdown.
shand.
/startup.
shcommands.
4.
Ifthefollowingerrormessagedisplaysintheconsolewindowforanyoftheapplicationservers,theissueisanHP-UXconfigurationproblem:OutofMemoryExceptionerror:UnabletocreatenewnativethreadonHP-UX.
TheproblemisthatthedefaultvaluesforHP-UX11.
0and11iaresettoolowformostJavaapplications.
Tip:Youcancheckthenumberofthreadsinyourprocessbyusingthe-eprofoptionavailableinJDK1.
1.
8andbyanalyzingtheJava.
eproffileusingHPjmeterbyselectingthethreadsmetric.
Chapter2.
Installationandconfigurationproblems25ContentManagerCannotConnecttotheContentStoreonOracleIfyouareusinganOracledatabaseasacontentstore,theDPR-ERR-2058errormaybegeneratedwhenloggingontotheportalAlltablesarecreatedonthedatabase.
Youmayalsoreceivethefollowingerrormessages:vCM-CFG-5036ContentManagerfailedtoconnecttothecontentstore.
vORA-01017:invalidusername/password;logondeniedSettingtheOracledatabaseservername:TheContentManagermightfailtoconnecttoanOracledatabasebecauseofinconsistenciesbetweentheOracleservernameinIBMCognosConfigurationandtheservernameinthetsnnames.
orafile.
Procedure1.
StartIBMCognosConfiguration.
2.
IntheExplorerwindow,clickDataAccess,ContentManager,ContentStore.
3.
ChangetheOracledatabaseservernametoafullyqualifiednamesuchashost_name.
companyname:1534tomatchthenameinthetnsnames.
orafile.
DPR-ERR-2022errordisplaysinWebbrowserwhenstartingIBMCognosAnalyticsAfteryoustarttheservicesinIBMCognosConfigurationandthentrytoopentheportal,amessagesimilartothefollowingmaydisplay:DPR-ERR-2022Noresponsegenerated.
Thismaybeduetoanincorrectconfiguration,adamagedinstallation,orthedispatchernothavingfinishedinitializing.
ThisproblemcanoccurifvYoutrytoopentheportalbeforeIBMCognosservicesareinitialized.
vAsystem.
xmlfilehasbeenedited.
Inthiscase,replacetheeditedsystem.
xmlfileintheappropriatesubdirectoryininstall_location\templates\pswithacopyfrombackuporuseanXMLeditortoeditit.
Therearemanyinstancesofsystem.
xmlinthedirectoriesininstall_location\templates\ps.
Ensurethatyoureplacethecorrectfile.
CorruptcharacterswhileinstallinginsomelanguagesonLinuxWhenrunningtheinstallationwizardonLinuxinKorean,Chinese(simplifiedortraditional),orJapanese,youmayseecorruptedcharactersinthedialogboxesoftheuserinterfaceorinmessagesthatdisplayduringtheinstallation.
Toavoidtheproblemofcorruptcharactersintheuserinterfaceduringinstallation,youcanuseoneofthefollowingsolutions:vConfiguretheAsianfontsontheLinuxserver:–Setthelocaletoutf8.
Forexample,ko_KR.
utf8,ja_JP.
utf8,zh_CN.
utf8,orzh_TW.
utf8–EnsurethatAsianlanguageFontset*medium-r*--14*isavailableonXserver.
26IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidevRunanunattendedinstallationusingthedefaultresponse.
atsfilethatisprovidedwithyourIBMCognosAnalyticsproduct.
Forinformationaboutsettingupanunattendedinstallation,seetheInstallationandConfigurationGuide.
Unabletodownloadthecognos.
xtsfileAfterinstallingIBMCognosAnalytics,youarepromptedtodownloadthecognos.
xtsfilewhenconnectingtotheIBMCognosAnalyticsportal.
Thefollowingerrormessagemaydisplay:Youhavechosentodownloadafilefromthislocation.
cognos.
xtsfromservernameThisproblemoccurswhenthepermissionsonthevirtualdirectoriesarenotsetproperly.
Youmustprovidethecgi-binvirtualdirectoryintheMicrosoftInternetInformationService(IIS)withexecutepermissions.
Toresolvethisproblem,recreatethevirtualdirectoriesinIISwiththepermissionsfromthefollowingtable,whereinstall_locationrepresentstheinstallationlocation.
Table4.
Alias,path,andpermissionsforcreatingIISvirtualdirectoriesAliasPathPermissionsibmcognosinstall_location\webcontentReadibmcognos\cgi-bininstall_location\cgi-binReadExecuteForexample,thedefaultinstallationlocationisC:\ProgramFiles\IBM\Cognos\install.
ApplicationserverstartupscriptfailsYoumayhaveproblemsrunningthestartupscriptsforanapplicationservertodeploytheIBMCognosapplicationifIBMCognosAnalyticscomponentsareinstalledinadirectorywithanamethatincludesspaces.
Procedure1.
Reinstalltoanewdirectoryanddonotincludespacesinthenewname.
2.
Ifthissolutionisnoteasilyhandledbythestartupscripts,tryaddingquotationmarksaroundthedirectorynamethatincludesspacesorusethe8.
3DOSnamingconvention.
DeployingtoanOracleApplicationServerwhenIBMWebSphereApplicationServerfailsDeployingIBMCognosAnalyticstoanOracleapplicationserveroranIBMWebSphereapplicationservermayfail.
Theseerrorscanoccurbecausetheapplicationfilethatyouaretryingtodeployistoolarge.
Ifadeploymentfails,anyofthefollowingerrorsmayoccur:Browsertimeoutinadministrationconsole.
HTTP500InternalError.
Deploymentfailed:BaseException:java.
rmi.
RemoteException(Oracle).
ReturntoapplicationfileselectionpageinIBMWebSphere.
Chapter2.
Installationandconfigurationproblems27FormoreinformationaboutdeployingIBMCognosAnalyticstoanapplicationserver,seetheIBMCognosAnalyticsInstallationandConfigurationGuide.
Procedure1.
IfyouareusingtheBuildApplicationWizard,cleartheIncludestaticfilesfromtheWebcontentfoldercheckboxwhenyouselecttheapplicationtobuild.
Thiswillreducethesizeoftheapplicationfile.
Ifstaticcontentisrequired,youcanmanuallycopyittothedeployedapplicationlocationafteryouhavesuccessfullydeployedIBMCognosAnalyticsintotheapplicationserver.
2.
IfyouaredeployingtheapplicationfilemanuallyforanOracleapplicationserver,typethefollowingcommand:dcmctldeployapplication-fpath_and_name_of_ear_file-aapplication_name-coOC4J_instance_nameThiscommandisnotsupportedforOracleRelease3.
Accentedordouble-bytecharactersmaynotdisplaycorrectlywheninstallingIBMCognosAnalyticsonLinuxIfyouareusingissetupunderaUTF-8locale,accentedordouble-bytecharactersmaynotdisplaycorrectly.
Procedure1.
ToresolvethisproblemwheninstallinginGermanorFrench,useanon-UTF-8localeandthenlaunchissetuptoinstallIBMCognosAnalytics.
2.
ToresolvethisproblemwheninstallinginJapanese,changetheencodingsettingofXTerminaltoShift-JIS,andtheninstallIBMCognosAnalyticsusinganunattendedinstallation.
Formoreinformation,seetheIBMCognosAnalyticsInstallationandConfigurationGuide.
RSV-SRV-0066asoapfaulthasbeenreturnedorRQP-DEF-0114theusercancelledtherequesterrorsdisplayinhighuserloadenvironmentsTheseerrorsmaybeintheIBMCognoscogaudit.
logifyouhaveahighuserload(over165users)andinteractivereportsarerunningcontinuouslyinadistributedinstallation.
Procedure1.
Increasetheasync_wait_timeout_msparameterparameterinwebapps/p2pd/WEB-INF/services/reportservice.
xmlfile.
Formoreinformation,seetheIBMCognosAnalyticsInstallationandConfigurationGuide.
2.
IncreasetheQueueTimeLimitsettingto360.
Forinformation,seetheIBMCognosAnalyticsAdministrationandSecurityGuide.
ProblemsconfiguringIBMCognosAnalyticsAfteryouinstallIBMCognosAnalyticscomponents,youmayencounterproblemswhenyousavechangesinIBMCognosConfiguration.
EnsurethatyouvconfigureandstarttheservicesonthecomputerwhereContentManagerislocatedbeforeyouconfigureothercomponents28IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidevrestarttheIBMCognosserviceafteryoumakeanyconfigurationchangesRunningDatabaseandIndexCleanupScriptsInsometroubleshootingsituations,youmaybeadvisedtostartwithnewconfigurationdata.
YoucanrunSQLscriptstodeleteallthetablesinanyofthefollowingdatabasesthatIBMCognosAnalyticscomponentsuse:vcontentstorefordatathatIBMCognosAnalyticsneedstooperatevdeliverydatabaseforreportnotificationsvdatabaseforhumantasksandannotationsYoucanrunSQLscriptstodeleteallthetablesandindexesintheloggingdatabaseforlogmessages.
Whenyoudeleteatable,itsstructuraldefinitionanddataaredeletedpermanentlyfromthedatabase.
Whenyoudeletetheindexesfromaloggingdatabase,theyaredeletedpermanentlyfromthedatabase.
WhenyourestarttheIBMCognosservice,anewsetofrequireddatabasetablesandindexesarecreatedautomaticallyinthelocationspecifiedbyyourconfigurationsettings.
Procedure1.
OneachcomputerwhereContentManagerislocated,stoptheIBMCognosservice.
2.
Gototheappropriatedirectory:vTodeletetablesandindexesfromtheloggingdatabase,gotoinstall_location\configuration\schemas\logging.
vTodeletetablesfromthecontentstore,gotoinstall_location\configuration\schemas\content.
vTodeletetablesfromthenotificationdatabase,gotoinstall_location\configuration\schemas\delivery.
vTodeletetablesfromthehumantaskandannotationdatabase,gotoinstall_location\configuration\schemas\hts.
3.
Gototheappropriatedatabasedirectory.
4.
Dependingonthedatabaseanddatabasetype,runoneofthefollowingscriptsintheappropriatedatabasetooltodeletethetables.
Thefollowingtableliststhescriptnamesforthecontentstoredatabase.
Table5.
DatabasetypeandscriptnameforthecontentstoredatabaseDatabasetypeScriptnameDb2dbClean_db2.
sqlDb2onz/OSdbClean_db2zOS.
sqlInformixdbClean_informix.
sqlMicrosoftSQLServerdbClean_mssqlserver.
sqlOracledbClean_oracle.
sqlSybasedbClean_sybase.
sqlChapter2.
Installationandconfigurationproblems29Thefollowingtableliststhescriptnamesforthenotificationdatabase.
Table6.
DatabasetypesandscriptnamesforthenotificationdatabaseDatabasetypeScriptnameDb2NC_DROP_DB2.
sqlDb2onz/OSNC_DROP_DB2.
sqlInformixNC_DROP_IFX.
sqlMicrosoftSQLServerNC_DROP_MS.
sqlOracleNC_DROP_ORA.
sqlSybaseNC_DROP_SYBASE.
sqlThefollowingtableliststhescriptnamestocleanuptablesandindexesfortheloggingdatabase.
ForInformix,theindexcleanupscriptmustbeeditedifyouhostmorethanoneauditloggingdatabaseontheInformixinstanceandusethematthesametime.
Seestep5.
Table7.
Scriptnamestocleanuptablesandindexesfortheloggingdatabase.
DatabasetypeScriptnameDb2LS_dbClean_db2.
sqlLS_dbCleanIndexes_db2.
sqlDb2onz/OSLS_dbClean_db2zOS.
sqlLS_dbCleanIndexes_db2zOS.
sqlInformixLS_dbClean_informix.
sqlLS_dbCleanIndexes_informix.
sqlMicrosoftSQLServerLS_dbClean_mssql.
sqlLS_dbCleanIndexes_mssql.
sqlOracleLS_dbClean_oracle.
sqlLS_dbCleanIndexes_oracle.
sqlSybaseLS_dbClean_sybase.
sqlLS_dbCleanIndexes_sybase.
sqlThefollowingtableliststhescriptnamesfortheHumanTaskandAnnotationdatabase.
Table8.
ScriptnamesfortheHumanTaskandAnnotationdatabaseDatabasetypeScriptnamealltypeshumanTaskService-dropScript.
sql5.
IfyouhavemorethanoneauditloggingdatabaseonyourInformixinstance,dothefollowing:vGotoinstall_location\configuration\schemas\logging\informixandopenthefileLS_dbCleanIndexes_informix.
sqlinatexteditor.
vReplaceeveryinstanceofIPFSCRIPTIDXwiththevaluethatyouspecifiedwhenyoucreatedtheIPFSCRIPTIDXpropertyinIBMCognosConfiguration.
Formoreinformation,seethetopicaboutspecifyingalogmessagesrepositoryintheIBMCognosAnalyticsInstallationandConfigurationGuide.
30IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidevSaveandclosethefile.
6.
StarttheIBMCognosservice.
ErrortryingtoencryptinformationwhensavingyourconfigurationWhenyousaveyourconfigurationusingtheconfigurationtool,youmayseeanerrormessagethatthecryptographicinformationcannotbeencrypted.
AnerroroccurredwhenrequestingacertificatefromtheCertificateAuthority.
Thecryptographicinformationcannotbeencrypted.
DoyouwanttosavetheconfigurationinplaintextBeforeyoucanencryptyourconfigurationsettings,thecomputerwhereContentManagerisinstalledmustbeconfiguredandrunning.
OnUNIXoperatingsystems,ensurethatyoucopiedtheappropriate.
jarfilestotheinstallationlocationofyourJavaRuntimeEnvironment.
Inaddition,ensurethatyourJavaenvironmentisconfiguredcorrectly,theURIsarecorrect,andthesamecertificateauthoritypasswordisconfiguredforallContentManagercomputers.
OnLinuxoperatingsystems,ensurethatyoucopiedtheappropriate.
jarfilestotheinstallationlocationofyourJavaRuntimeEnvironment.
Also,anerrormessagesimilartothefollowingmaydisplay:java.
lang.
NoClassDefFoundError:javax/net/ServerSocketFactory.
ThecryptographicerrorusuallymeanstheJavaenvironmentisnotconfiguredcorrectly.
EnsurethattheJAVA_HOMEenvironmentvariableissetcorrectlyandtheappropriatesecurityprovidersareinstalled,suchasJSSEforJRE1.
5.
CheckingtheURIpropertiesandcertificateauthoritypasswordToensurethatconfigurationsettingscanbeencrypted,ensurethattheURIpropertiesandcertificateauthoritypasswordinIBMCognosConfigurationarecorrect.
Procedure1.
OntheContentManagercomputer,startIBMCognosConfiguration.
2.
IntheExplorerwindow,clickEnvironment.
3.
InthePropertieswindow,verifytheseproperties:vUnderGatewaySettings>GatewayURIvUnderDispatcherSettings>ExternaldispatcherURIandInternaldispatcherURIvUnderOtherURISettings>DispatcherURIforexternalapplicationsandContentManagerURIs4.
IntheExplorerwindow,clickSecurity>Cryptography>Cognos.
5.
InthePropertieswindow,underCertificateAuthoritysettings,clickthevalueforPassword.
EnsurethatthesamepasswordisusedonallContentManagercomputers.
6.
SavetheconfigurationandrestartIBMCognosAnalytics.
Chapter2.
Installationandconfigurationproblems31ProblemsgeneratingcryptographickeysinIBMCognosConfigurationWhenyouuninstallIBMCognosAnalytics,sometemporaryfoldersareleftbehind.
ReinstallingtheproducttothesamelocationwithoutfirstremovingthetemporaryfoldersmaycauseproblemswhileattemptingtogeneratethecryptographickeysinIBMCognosConfiguration.
Procedure1.
UninstallIBMCognosAnalytics.
2.
Removetheinstall_location/temp/camfolder.
3.
ReinstallIBMCognosAnalytics.
CAM-CRP-1315errorwhensavingconfigurationWhenyousaveyourconfiguration,anerroroccurswhentherehasbeenachangetoyourenvironment'strustdomain.
ThereareseveralinstanceswhentheCryptographicKeysmayneedtoberegenerated.
BeginningwithCognos10.
2.
2,thetraditionalmethodtoregeneratethecryptographickeysisnolongervalidandthebelowstepswouldneedtobefollowedinstead.
Thetrustdomainismanagedbythecertificateauthorityassociatedwiththecontentstore.
ThefollowingerroroccursifthecontentstoreyouoriginallyusedwasremovedorifyoumodifiedyourconfigurationtouseaContentManagerassociatedwithadifferentcontentstoreafteryouhavesavedyouroriginalconfiguration.
CAM-CRP-1315CurrentconfigurationpointstoadifferentTrustDomainthanoriginallyconfigured.
Toresolvetheproblem,changeyourconfigurationtousetheoriginalcontentstoreorregeneratethecryptographickeysusingthefollowingsteps.
Procedure1.
Onthecomputerthatreportstheerror,stoptheCognosservicesandlaunchCognosConfigurationandclickFile>ExportAs.
2.
Removetheinstall_location/temp/cam/freshnessfile.
3.
Backuptheexistingcryptographickeysbysavingthefollowingdirectoriestoanalternatelocationthatissecure:vinstall_location/configuration/cskvinstall_location/configuration/certs4.
Deletethecskdirectory.
5.
ExceptforthejCAPublisherKeystorefile,whichmustberetained,clearthecertsdirectory.
6.
Repeatonallcomputersthatreportthiserror.
7.
InIBMCognosConfiguration,savetheconfigurationandrestarttheservices.
CAM-CRP-0221errorwhenloggingintotheportalAfterinstallingIBMCognosAnalyticsonMicrosoftWindowsoperatingsystem(eithera32-bitor64-bitsystem)andconfiguringIBMHTTPServerasthegateway,attemptstologintotheIBMCognosAnalyticsportalresultinanerrormessagethatcontainsthefollowing:32IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideCAM-CRP-0221Unabletoloadtheprovider'CAM_Crypto_TOpenSSL.
dll'specifiedintheconfigurationfile.
ThiserroroccurswhenincompatibleversionsofOpenSSLlibrariesareloaded.
Toresolvetheproblem,loadtheOpenSSLlibrariesthatareprovidedwithIBMCognosAnalytics.
Procedure1.
Onthegatewaycomputer,gotoIBM_HTTP_location\confdirectoryandopenhttpd.
confinatexteditor.
2.
Addthefollowinglinestothefile:LoadFile"install_location/cgi-bin/ssleay32.
dll"LoadFile"install_location/cgi-bin/libeay32.
dll"whereinstall_locationisthepathtotheIBMCognosAnalyticsinstallationdirectory.
ManuallychangingtheinstallationdirectorynameaffectsinstallationsrunningunderanapplicationserverAfterinstallingIBMCognosAnalyticsusingtheinstallationwizardandlaterrenamingtheinstallationdirectoryormanuallycopyingthecontentstoanotherdirectory,youattemptedtorunIBMCognosAnalyticswithinanapplicationserver.
Oneofthefollowingproblemsoccurs:vIBMCognosAnalyticsdoesnotstart.
vLogdirectoriesareempty.
vLogscontainalinkageerrororunsatisfiedlinkerror.
Whenyoumanuallychangetheinstallationdirectory,theinformationintheIBMCognosAnalyticsrootdirectorybecomesinvalid.
Toresolvetheproblem,youmusteitherupdatetheIBMCognosAnalyticsrootdirectorybeforeyoucreatetheIBMCognosAnalyticsapplicationfiletodeploytotheapplicationserveroryoumustreinstallIBMCognosAnalyticsintheoriginallocation.
IfyoureinstallIBMCognosAnalytics,followtheprocessforupgrading.
Procedure1.
Intheneworrenamedinstallationdirectory,openinstall_location/webapps/p2pd/WEB-INF/classes/cogroot.
linkinatexteditor.
2.
Replacethepathwiththenewlocationoftheinstallationdirectoryandsavethefile.
3.
Tobuildtheapplicationfiletobedeployedtotheapplicationserver,inIBMCognosConfiguration,fromtheActionsmenu,selectBuildApplicationFiles.
4.
Ifyoubuiltanddeployedanapplicationfiletotheapplicationserverbeforeupdatingthecogroot.
linkfile,undothedeployment.
5.
Deploythenewapplicationfiletotheapplicationserver.
FormoreinformationaboutconfiguringIBMCognosAnalyticsforanotherapplicationserver,seetheIBMCognosAnalyticsInstallationandConfigurationGuide.
Chapter2.
Installationandconfigurationproblems33ConfigurationdataislockedbyanotherinstanceofIBMCognosConfigurationYoumaygetanerrormessagethattheconfigurationdataislockedbyanotherinstanceofIBMCognosConfiguration.
WhenyoustartIBMCognosConfiguration,itcheckstoseeifthecogstartup.
lockfileexistsininstall_location/configuration.
ThefilemayexistifapreviousinstancedidnotshutdownproperlyorifanotherinstanceofIBMCognosConfigurationisrunning.
Procedure1.
IfanotherinstanceofIBMCognosConfigurationisrunning,exitthatinstance.
Otherwise,anychangesyoumaketothelocalconfigurationmayresultinerrors.
2.
IfnootherinstanceofIBMCognosConfigurationisrunning,deletethecogstartup.
lockfileininstall_location/configuration.
3.
IftheIBMCognosserviceisstopped,clickStart.
Unabletoexitatabsequencewhenusingkeyboard-onlynavigationinIBMCognosConfigurationIfyouusetheTabkeytonavigateinIBMCognosConfiguration,youmayexperienceproblemsexitingatabsequence.
Forexample,inthePropertieswindow,youcanpresstheTabkeytomovefromonepropertytoanother.
However,becauseIBMCognosConfigurationisaJavaapplication,whenyouwanttoclosethePropertieswindow,youmustpressCtrl+Tab.
UnabletosaveyourconfigurationYoumaybeunabletosaveyourconfigurationbecauseyouaremissingaresource.
Forexample,youdeletearesourcesuchastheCognosnamespace,acryptographicprovider,orthecontentstore.
YoucanspecifyadifferentdatabasetypeforthecontentstorewithOracle,MicrosoftSQLServer,Informix,orSybase.
Youcanalsoconfigureanewcryptographicprovider.
YoucannotspecifyanewCognosnamespace,butyoucanrecreateit.
However,youmustthenrecreateyourCognosgroupsandroles.
RecreatingtheCognosnamespaceIfyoudeletedtheCognosnamespace,youmustrecreateitandthenrecreateyourCognosgroupsandroles.
Procedure1.
StartIBMCognosConfiguration.
2.
IntheExplorerwindow,underSecurity,right-clickAuthenticationandthenclickNewresource>Namespace.
3.
IntheNamebox,typeanamefortheresource.
4.
IntheTypebox,clickCognos,andthenclickOK.
TheCognosnamespacedisplaysintheExplorerwindow.
5.
FromtheFilemenu,clickSave.
6.
RecreatetheCognosgroupsandrolesusingIBMCognosAdministration.
Formoreinformation,seetheIBMCognosAnalyticsAdministrationandSecurityGuide.
34IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideJavaerrorwhenstartingIBMCognosConfigurationWhenyoustartIBMCognosConfiguration,youmayreceiveanerrormessagethattheJavaRuntimeEnvironment(JRE)haschangedandthatthecurrentcryptographicinformationisnotcompatiblewiththenewJRE.
YoumaythenbepromptedtoregeneratethecryptographicinformationforthenewJREorexittoswitchbacktothepreviousJRE.
Thiserrormayoccurforoneofthesereasons:vYourconfigurationdatawasencryptedusingadifferentJREthantheoneIBMCognosAnalyticscomponentsarecurrentlyusing.
vThecryptographicinformationmayhavebeencorrupted.
IfyouclickRegenerateintheerrordialog,theIBMCognosserviceisstoppedandthecryptographicinformationisregenerated.
IfyouclickExitintheerrordialog,youmustsettheJAVA_HOMEenvironmentvariabletopointtotheJREthatyouusedtosaveyourconfiguration.
OnMicrosoftWindowsoperatingsystem,ifyouwantIBMCognosAnalyticscomponentstousetheJREthatisinstalledbydefault,unsetJAVA_HOMEorsetJAVA_HOMEtoinstall_location/bin/jre.
Note:IfyouwanttochangefromoneJREtoanother,seethetopiconchangingtheversionofJVMthatIBMCognosAnalyticscomponentsuse.
Formoreinformation,seetheInstallationandConfigurationGuide.
CryptographicerrorwhenstartingIBMCognosConfigurationWhenyoustartIBMCognosConfiguration,thefollowingerrormessagemaydisplay:Thecryptographicinformationmayhavebeencorruptedorthecogstartup.
xmlfileisinvalid.
Youmayhavetofixthisfileorremoveitfromdisk.
Formoreinformation,seetheInstallationandConfigurationGuide.
ThiserroroccurswhenIBMCognosAnalyticscomponentsdetectanerrorinthecogstartup.
xmlfile.
Thiscanoccurwhenthecogstartup.
xmlfileismanuallyeditedandthereisanerrorinthechangedtext.
Toresolvetheproblem,replacethecogstartup.
xmlfilewithacopyfromyourbackuplocation.
RestartingtheIBMCognosservicetoapplyconfigurationsettingsAfterchangingdefaultpropertyvaluesoraddingaresourcetoyourinstallationinIBMCognosConfigurationandthensavingtheconfiguration,youmaynotseethechangesorbeabletousetheresourceintherun-timeenvironment.
Toapplythenewsettingstoyourcomputer,youmustrestarttheIBMCognosservice.
Procedure1.
StartIBMCognosConfiguration.
2.
FromtheActionsmenu,clicktheappropriatecommand:Chapter2.
Installationandconfigurationproblems35vIftheIBMCognosserviceiscurrentlyrunning,clickRestart.
Thisactionstartsallinstalledservicesthatarenotrunningandrestartsservicesthatarerunning.
Ifyouwanttorestartaparticularservice,selecttheservicenodeintheExplorerwindowandthenclickRestartfromtheActionsmenu.
vIftheIBMCognosserviceisstopped,clickStart.
Thisactionstartsallinstalledservicesthatarenotrunning.
Ifyouwanttostartaparticularservice,selecttheservicenodeintheExplorerwindowandthenclickStartfromtheActionsmenu.
CM-CFG-029errorwhentryingtosaveaconfigurationthatspecifiesaMicrosoftSQLServercontentstoreInIBMCognosConfiguration,youtrytosaveaconfigurationandthefollowingerrormessageisinthecogaudit.
logfile:CM-CFG-029ContentManagerisunabletodeterminewhetherthecontentstoreisinitialized.
EXECUTEpermissionisdeniedonobject"sp_tables",database"master",owner"dbo'.
Thisindicatesthatyoudonothavethecorrectpermissionstoinitializeacontentstoreorcreateatableinthedatabase.
Ensurethatthecontentstoreuserhaspermissionstousethesp_tablesstoredprocedureinthemasterdatabase.
Db2notfounderrorforLinuxonSystemzYouinstalledIBMCognosAnalyticsandafteryourantheC8DB2.
shscript,anerrorstatingthatDb2cannotbefoundisdisplayedorwrittentothelogfiles.
Procedure1.
Createaprofilethatsourcesthesqllib/db2profilefromtheuser'shomedirectoryfortheuseryouenterwhenyourunthescript.
Anexample.
profilewouldcontainsomethinglikethefollowing:if[-f/home/db2user/sqllib/db2profile];then.
/home/db2user/sqllib/db2profilefi2.
RuntheC8DB2.
shscriptagain.
DPR-ERR-2079whenContentManagerconfiguredforfailoverYouconfiguredmultiplecomputersasstandbycomputerstoensurefailoverforContentManager.
However,thefollowingerrormessagedisplaystotheuser:DPR-ERR-2079FirewallSecurityRejection.
YourrequestwasrejectedbythesecurityfirewallThiserrormessagecanoccurifyouhavenotconfiguredallthestandbycomputersasvalidhostsfortheIBMCognosApplicationFirewall.
Tosolvethisproblem,oneachdistributedcomputer,startIBMCognosConfigurationandenterthenamesofallthecomputersthatyouareconfiguringforfailover.
36IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideProcedure1.
IntheExplorerpane,clickSecurity>IBMCognosApplicationFirewall.
2.
IntheIBMCognosApplicationFirewall-ComponentPropertieswindow,clickintheValuecolumnnexttoValiddomainsorhosts.
3.
Clicktheediticon.
4.
Enterthenamesofallthecomputersthatyouareconfiguringforfailover.
5.
Saveandstarttheconfiguration.
ImportingalargedeploymentinWindowscrashestheJavavirtualmachineTheJavavirtualmachineunderMicrosoftWindowsoperatingsystemmaycrashunderthefollowingcircumstances.
vThemaximumJavamemorysettingis1152MBorhigher.
vYouareimportingalargearchivefromapreviousreleaseofIBMCognosAnalytics.
vThearchivecontainslargemodelsthatrequireupgrading.
Procedure1.
StartIBMCognosConfiguration.
2.
IntheExplorer,underEnvironment,IBMCognosservices,clickIBMCognos.
3.
SettheMaximummemoryinMBpropertyto768.
CCL-BIT-0006errormessagewhenusingWebSphereApplicationServeronaheavilyloadedsystemOnaheavilyloadedsystemthatusesWebsphereApplicationServer,someconnectionsmightterminatebeforeIBMCognosAnalyticsfinishesprocessingarequest.
Youmightseethefollowingmessageintheinstall_location/logscogaudit.
logfile:FailureRSV-SRV-0063Anerroroccurredwhileexecutingthe'asynchRun_Request'command.
CCL-BIT-0006TheHTTPmessageisunexpectedlyshort.
Whentheconnectionclosesbeforetherequestisprocessed,therequestislostandtheusermustresubmittherequest.
YoucanhelpreducethefrequencyofthiserrorbyincreasingthePersistentTimeoutparameterfortheWebcontainertransportchainsintheWebSphereAdministrativeConsole.
Increasethetimein10-15secondintervalsuntiltheerrornolongerorrarelyoccurs.
FontonUNIXnotfoundwhenstartingIBMCognosConfigurationAcommonproblemoccursonUNIX,whenyoustartIBMCognosConfiguration.
Thefollowingerrormessagemaydisplay:Fontspecifiedinfont.
propertiesnotfound.
.
.
Chapter2.
Installationandconfigurationproblems37ThiserroroccursiftheJavaVirtualMachine(JVM)istryingtouseoneormorefontsthatarenotinstalledonyourcomputer.
However,theJVMshouldusethesystemdefault,andIBMCognosConfigurationshouldstartandrunnormally.
ProcedureAddthemissingfontstoyourJavaRuntimeEnvironmentbyeditingthefont.
propertiesfiles.
Severalfont.
propertiesfiles,whichcontainstandardfontenvironmentinformation,areinstalledwithyourJavaSoftwareDevelopmentKit.
YoucanfindthesefilesintheJRE_location/libdirectory.
Formoreinformation,seetheJavadocumentation.
ESSBASEPATHcannotbedetectedForMicrosoftWindowsandUNIXplatforms,OracleEssbasesoftwareusestheESSBASEPATHenvironmentvariabletolocatetheEssbase11clientsoftware.
TheOracleHyperionEnterprisePerformanceManagement(EPM)SystemInstallercreatesESSBASEPATHasauserenvironmentvariable.
IftheIBMCognosserviceisconfiguredtorunorlogonasasystemaccount,youmustmanuallyaddESSBASEPATHasasystemenvironmentvariable,ifitdoesnotexist.
WhenIBMCognossoftwarecannotlocatetheESSBASEPATHenvironmentvariable,youreceivethefollowingerror:DB2-ERR-0044Essbaseenvironmentvariable"ESSBASEPATH"cannotbedetected.
CheckifEssbaseclientisinstalled.
Toresolvethisissue,dooneofthefollowing,andthenrestarttheIBMCognosservice:vDouble-clickIBMCognosservice,andontheLogOntab,specifyauseraccountthathasaccesstoESSBASEPATH.
vAddESSBASEPATHasasystemenvironmentvariable.
NotethatifyouareupgradingtoEssbase11softwarefromEssbase9software,youmustinstalltheappropriateclientandthenedittheqfs_config.
xmlfiletochangethelibraryname.
Changingthelibrarynameintheqfs_config.
xmlfileIfyouareupgradingtoEssbase11softwarefromEssbase9software,thenafterinstallingtheappropriateclient,youmustchangethelibrarynameintheqfs_config.
xmlfile.
Procedure1.
Intheinstall_location/configurationdirectory,openthefilenamedqfs_config.
xml.
2.
Findthelineofcodeandchangethelibrarynamefromessodp93toessodp111.
3.
Savethechanges.
38IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideProblemstestingdatasourceconnectionswithIBMCognosAnalyticsdeployedonSAPNetWeaverApplicationServer7.
1.
1onUNIXIfyouhavedeployedIBMCognosAnalyticsonSAPNetWeaverApplicationServer7.
1.
1runningonaUNIXoperatingsystem,youmayreceiveanerrorwhenyoutestyourdatasourceconnectionsinIBMCognosAdministration.
Toresolvethisproblem,youmustupdatethelibrarypathandallpathsusedfordatabaseclientaccessinaSAPenvironmentfilenamed.
sapenv_servername.
sh,whereservernameisthenameofyourserver.
Procedure1.
GototheSAPadministratoruser'shomedirectory.
2.
Locatethefilenamed.
sapenv_servername.
sh,whereservernameisthenameofyourserver.
3.
Openthefileinatexteditor.
4.
Addinstall_location/bin64tothelibrarypathandanypathlocationsrequiredfordatabaseclientaccess.
Forexample,ifyouhaveinstalledIBMCognosAnalyticsto/server1/home/ibm/cognos/install,yourlibrarypathwouldlooklikethefollowing:LIBPATH=/server1/home/ibm/cognos/install/bin64:/db/oracle/11.
1.
0.
6/lib32:/server1/home/db2user/sqllib/lib32:/usr/lib:/lib:$_DEF_EXE;exportLIBPATH5.
Savethefile,andrestarttheSAPandIBMCognosAnalyticsprocesses.
6.
Testyourdatabaseconnections.
GroupmembershipismissingfromActiveDirectorynamespaceIfanActiveDirectorynamespaceisconfiguredforthesameforestandauserisauthenticatedusingacredential,thegroupmembershipwillbemissing.
TheprocessidentityofIBMCognosAnalytics,whenrunningasalocalsystemaccountoradomainuser,musthaveoneoftheseprivileges:vimpersonateaclientafterauthenticationvactaspartoftheoperatingsystemIftheprivilegeismissing,thereisnogroupmembershipfortheauthenticateduser.
AddinggroupmembershipforanActiveDirectorynamespaceToaddgroupmembershipforanActiveDirectorynamespace,youmustaddtheprocessidentityforIBMCognosAnalyticstothelocalsecuritypolicy.
Procedure1.
FromtheStartmenu,clickSettings,ControlPanel.
2.
ClickAdministrativeTools,andthendouble-clickLocalSecurityPolicy.
3.
Intheconsoletree,clickSecuritySettings,LocalPolicies.
4.
ClickUserRightsAssignment.
5.
AddtheprocessidentityofIBMCognosAnalyticstooneofthefollowingpolicies:Chapter2.
Installationandconfigurationproblems39vImpersonateaclientafterauthenticationThedefaultisAdministrators,Service.
Formoreinformation,seethelibraryarticlefe1fb475-4bc8-484b-9828-a096262b54ca1033.
mspxattheMicrosoftWebsite.
vActaspartoftheoperatingsystemThedefaultisLocalsystem.
Formoreinformation,seethelibraryarticleec4fd2bf-8f91-4122-8968-2213f96a95dc1033.
mspxattheMicrosoftWebsite.
Bothoftheseprivilegesgiveanaccounttheabilitytoactasanotheruser.
TheprivilegeImpersonateaclientafterauthenticationissimilartotheActaspartoftheoperatingsystemprivilegeexceptthatitwillonlyallowaprocesstoimpersonateafterauthentication,whereastheprivilegeActaspartoftheoperatingsystemallowsaprocesstoimpersonatebeforeauthentication.
Formoreinformation,seethelibraryarticletkerbdel.
mspxattheMicrosoftWebsite.
QueryfailswhenusingOracleEssbaseServerYourunaquerytoretrievemetadataordatafromanOracleEssbaseserverandyoureceiveamessagesimilartooneofthefollowingmessages:vTheIBMCognosgatewayisunabletoconnecttotheIBMCognosAnalyticsserver.
Theservermaybeunavailableorthegatewaymaynotbecorrectlyconfigured.
vDB2-ERR-0005Anunknownerroroccurredduringthelogin.
Databaseerrorcode:1,042,006.
vXQE-DS-0006Unabletologontothedatasource.
TheseIBMCognoserrorscanresultfromWindowsnothavingenoughsocketsorportsavailableontheMicrosoftWindowsoperatingsystem.
AlackofsufficientportscancausedataretrievalfromEssbasetofailbecauseofnetworkcommunicationerrors.
Toresolvethisproblem,increasethenumberofWindowssocketsorportsthatareavailableforprogramuse.
IncreasingthenumberofWindowssocketsorportsToresolveconnectionerrorswithanOracleEssbaseServer,increasethenumberofsocketsorportsontheMicrosoftWindowsoperatingsystemthatareavailableforprogramusebyaddingtwoentriesinMicrosoftRegistryEditor.
Important:UseMicrosoftRegistryEditoratyourownrisk.
Incorrectusemaycauseproblemsthatrequireyoutoreinstallyouroperatingsystem.
MicrosoftcannotguaranteethatyoucansolveproblemsthatresultfromusingRegistryEditorincorrectly.
Procedure1.
FromtheWindowsStartmenu,runtheregeditapplication.
2.
IntheHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parametersdirectory,createanewDWORDvaluenamedMaxUserPort.
3.
SetthepropertiesforMaxUserPorttouseavalueof65534andabaseofDecimal.
Therangeforvalueisfrom30000to65534.
4.
Inthesamedirectory,addanotherDWORDvaluenamedTcpTimedWaitDelay.
40IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuide5.
SetthepropertiesforTcpTimedWaitDelaytouseavalueof50andabaseofDecimal.
Therangeforvalueisfrom30secondsto300seconds,withadefaultvalueof240seconds(4minutes).
6.
Afterclosingtheregeditapplication,restarttheMicrosoftCRMserverorrestartyourcomputer.
ResultsFormoreinformation,visitthetechnet2.
microsoft.
comWebsiteandsearchonthetermsMaxUserPortandTcpTimedWaitDelay.
ErrorsdisplayedwhendeployingtoOracle10GApplicationServerYouaredeployingIBMCognosAnalyticstoanOracle10GApplicationServer.
Thefollowingerrormessagemayoccur:MDS-RUN-3213Unabletolocatedatabasebulkloadutility.
Pleaseinstalltheappropriatedatabasetoolforthisplatform('bcp'forSQLServer,'sqlldr'forOracle)Theseerrorsoccurbecausethebulkloadingutilities(SQLLoaderonOracle)arenotincludedinthedeploymentfilecreatedbyIBMCognosConfiguration.
ProcedureToinstallthemissingcomponents,usetheOracleclientsoftwareonthecomputerwhereyouinstalledtheOracle10GApplicationServer.
EnsurethatyouinstallSQLLoader.
CGItimeouterrorwhileconnectedtoIBMCognosAnalyticsthroughaWebbrowserWhenperformingoperationsthroughyourWebbrowser,youreceivethefollowingerrormessage:CGITimeout,processwillbedeletedfromserver.
TheerroroccurswhenyouuseMicrosoftInternetInformationServices(IIS)asyourWebserverandthegatewayisconfiguredtouseCGI.
IIShasadefaulttimeoutforCGIapplications;youcanincreasetheCGItimeoutinIISIncreasingtheCGItimeoutToresolveaCGItimeouterrorintheWebbrowser,youcanincreasethedurationoftheCGItimeoutinIIS.
Procedure1.
IntheadministrativetoolsforMicrosoftWindowsoperatingsystem,openInternetInformationServices.
2.
Underthelocalcomputernode,right-clickWebsitesandselectProperties.
3.
IntheHomeDirectorytab,clickConfiguration.
4.
IntheProcessOptionstab,increasetheCGIscripttimeout.
Chapter2.
Installationandconfigurationproblems41DesktopiconsorIBMCognosConfigurationwindowflickeronWindowsWhenyourunIBMCognosConfigurationonMicrosoftWindowsoperatingsystem,youmaynoticethatthedesktopiconsortheIBMCognosConfigurationwindowflickers.
ProcedureStartIBMCognosConfigurationusingthe-noddrawcommandlineoption.
MissingtranslationsforobjectnamesinsomelocalesAfteryouupgradeIBMCognosAnalyticsorimportanarchive,someobjectnamesmightnotbelocalizedforcertainlocales.
Forexample,namesdisplayinEnglish,andnotinthespecifiedlanguage.
Thisproblemmightoccurinthefollowingsituations:vCognosAnalyticswasupgradedtoanewerversion,butanoldercontentstoreversionwasconfiguredastheactiveContentManager.
vAnarchivethatwascreatedwithIBMCognosBusinessIntelligenceoranolderversionofCognosAnalyticswasimportedintoanewerversionofCognosAnalytics.
Forexample,youmightencounteruntranslatedobjectnamesintheCatalan,Croatian,Danish,Greek,Kazakh,Norwegian,Slovak,Slovenian,orThailocaleifyourIBMCognosBusinessIntellignce10.
2installationisconfiguredwiththe10.
1versionofContentManager.
Supportfortheabove-mentionedlocaleswasaddedinIBMCognosBusinessIntellignceversions10.
1.
1and10.
2soyour10.
1versionofContentManagerdoesnothavethesetranslations.
ToaddthetranslationsintotheCognosAnalyticsenvironment,performthefollowingprocedure.
Procedure1.
StartIBMCognosConfigurationonthecomputerwheretheactiveContentManagerserviceisinstalled.
2.
FromtheActionsmenu,clickEditGlobalConfiguration.
3.
ConfirmthattherequiredlocalesarelistedontheContentLocalesandProductLocalestabs.
Ifthelocalesaremissing,addthemandsaveyourchanges.
4.
Gotoinstall_location/webapps/p2pd/WEB-INF/classesdirectory,andconfirmthatacmmsgsRL_locale.
propertiesmessagefileexistsforeachrequiredlocale.
Forexample,forSlovenianthismessagefileisthecmmsgsRL_sl.
propertiesfile.
5.
Intheinstall_location\configurationdirectory,copytheupdateInitialContentNames.
xml.
samplefileandsaveitasupdateInitialContentNames.
xml.
6.
EdittheupdateInitialContentNames.
xmlfile:a.
Specifythelocalesthatyouwanttoadd.
Forexample,modifythefileinthefollowingwaytodisplayCroatianandSlovenianobjectnames:hrsl42IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideb.
Removeorcommentoutanyotherlocalesthatarenotaffectedbythelocalizationissue.
c.
Saveyourchanges.
7.
StarttheIBMCognosservice.
8.
Toaddanotherlocalelater,repeatthesesteps.
ResultsThelocalizedobjectnamesareaddedduringtheIBMCognosservicestartupprocess.
Youcanviewtheresultsoftheoperationinthecogaudit.
logfile.
TheupdateInitialContentNames.
xmlfileisdeletedintheprocesstopreventunnecessaryupdatesoneachrestart.
Chapter2.
Installationandconfigurationproblems4344IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideChapter3.
SecurityProblemsYoumayencounterproblemswhenyouadministersecurityforIBMCognoscomponents.
ProblemsSettingUpSecurityThetopicsinthissectiondocumentproblemsyoumayencounterwhensettingupsecurity.
AccesstoEntriesIsDeniedDuringDeploymentIfyoudeploydatausingtheReportsAdministratorrole,accesstosecurityentriesmaybedenied.
Bydefault,theReportsAdministratorroledoesnothavewriteaccesstotheCognosnamespace.
Beforeyoudeploy,modifythepermissionsofthisroletoensurethatithasreadandwritepermissionstotheCognosnamespace.
PrompttoChangePasswordsWhenLoggingontoanActiveDirectoryNamespaceWhenloggingontoIBMCognoscomponentsusingaMicrosoftActiveDirectorynamespace,thesubmittedpasswordisrecognizedasexpiredandyouarepromptedtochangeit.
Thisoccursevenifthepasswordshouldstillbevalid.
Ifthepasswordissuccessfullychanged,thebehaviorstilloccurs.
Thefollowingerrormessageappears:Yourpasswordhasexpired.
Pleasechangeit.
Pleasetypeyourcredentialsforauthentication.
ThesolutionistosetuptheauthorityfordelegatedadministrationforIBMCognoscomponents.
EnsurethattheservernameornamedaccountforstartingtheIBMCognosserviceissetupintheActiveDirectorypropertiesasanauthorityfordelegatedadministration.
Withoutthesepermissions,IBMCognoscomponentsareunabletoreadalluserpropertiesfromtheActiveDirectoryserver.
Formoreinformation,seetheActiveDirectorydocumentation.
UnabletoLogonIfIBMCognoscomponentsuseanActiveDirectoryServerasthesecurityprovider,youmaynotbeabletologonusingonlyyouruserID.
Oneofthefollowingerrorsmayappear:Yourpasswordhasexpired.
Pleasechangeit.
Theprovidedcredentialsareinvalid.
ThisproblemoccurswhentheContentManagerservicerunsunderthelocalsystemaccountandrunsonacomputerthatisnotpartoftheActiveDirectoryServerdomain.
45Tologon,youmustqualifyyouruserIDusingthedomainname.
Forexample,whenyoulogon,typedomain\userIDIfyoustillcannotlogon,contactyourIBMCognossecurityadministrator.
CertificateAuthorityErrorWhenLoggingonYouattempttologon,enteringavaliduserIDandPassword,inanenvironmentthatusesthedefaultIBMCognosCryptographicProvidersettings.
However,thefollowingerrormessageappears:CAM-CRP-1071Unabletoprocessaremoterequestforthecommonsymmetrickey.
ThecertificatewiththeDN'C=CA,O=Cognos,CN=CAMUSER'issuedbytheCertificateAuthoritywiththeDN'C=CA,O=Cognos,CN=CA'isnottrusted.
Reason:ExceptionthrownwhiledoingCertPathvalidationCause:certificateexpiredonyyyymmddhhmmGMT+00:00ThisproblemoccurswhenthecertificateissuedbytheCertificateAuthority(CA)hasexpired.
YoucanrenewthecertificatebysavingtheconfigurationinIBMCognosConfigurationonthecomputerwhereContentManagerisinstalledandthenrestartingtheIBMCognosservice.
HTTPSDRP-ERR-2068ErrorinLogFileWhennoErrorIsReportedDuringaSwitchtoHTTPSYoustoppedtheservicesonallcomputersinadistributedinstallationandconfiguredthecomputerstouseSSL(HTTPS).
Youstartedtheservicessuccessfully,withnoreportederrors.
However,whenyoucheckedthelogfile,youfoundanerrorsimilartothefollowing:HTTPSDPR-ERR-2068Theadministrationrequestfailed.
Cannotconnecttodispatcher.
Theerroroccurredbecausewhenyourestartedtheservices,thedispatcherswereinitializingandcouldnotcommunicatewitheachother.
Duringtheinitialization,anormaladministrationrequestcouldnotbeprocessedandafaultwasgenerated.
Thefaultwasrecognizedasaninitializationfaultandsonoerrorwasshownduringthestartup.
However,IBMCognosApplicationFirewalldoesnotdistinguishbetweenaregularfaultandaninitializationfault.
Asasecuritybestpractice,allmessagesaresenttothelogfile.
Youcanignorethemessageinthelogfile.
EntriesDoNotAppearforaMemberofaNewlyCreatedGroupAuserwhoisamemberofanewlycreatedgroup,whichisitselfamemberoftheQueryUsersgroup,logson.
Theuserseesthatsomeentries,suchasMyFolders,aremissing.
Theusernamemayalsobemissingfromtheupper-leftcornerofthepage.
ThenamespacethattheuserbelongstomusthavetraverserightstotheQueryUsersgroup.
Procedure1.
OntheSecuritytabinIBMCognosAdministration,clickUsers,GroupsandRoles.
46IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuide2.
NexttotheCognosnamespace,clickthesetpropertiesbutton.
3.
ClickthePermissionstab.
4.
Ifitisnotalreadythere,addtheQueryUsersgrouptothenamespace.
5.
ClickthecheckboxforQueryUsersandensurethatTraversepermissionsaregranted.
6.
ClickApply,andclickOK.
7.
Testwithauser.
ExistingPasswordsMaynotWorkinanSAPNamespaceWhenyoulogonusinganSAPnamespace,somepreviouslyfunctionalpasswordsmaynolongerwork.
Thefollowingerrormessagemayappear:Unabletoauthenticateauser.
Pleasecontactyoursecurityadministrator.
Pleasetypeyourcredentialsforauthentication.
ThisisbecauseofapolicychangeinSAPsoftware.
InpreviousversionsofSAPsoftware,passwordswerenotcasesensitive.
Allpasswordcharacterswereautomaticallyconvertedtouppercase.
InSAPRFC6.
40,passwordcharactersarenotautomaticallyconvertedtouppercaseandsopasswordsarecasesensitive.
Toaddressthepasswordpolicychange,theSAPBAPIinterfaceintroducedanewconfigurationparameternamedbapiPasswordConv.
Usingthisparameter,youcanenableordisablethefunctionalitythatautomaticallyconvertsallpasswordcharacterstouppercase.
Toensurethatallpreviouslycreatedpasswordscanstillprovidesuccessfullogon,setthevalueofthebapiPasswordConvparametertotrue.
Procedure1.
Openthefilebapiint_config.
xml.
Thisfileislocatedinthec8_location\configurationdirectory.
2.
ChangethevalueofthebapiPasswordConvparametertotrue,asshowninthefollowingfragmentofcode:3.
Savethefile.
4.
RestarttheIBMCognosservice.
ResultsFormoreinformation,seethefollowingSAPNotes:v792850-PreparingABAPsystemstodealwithincompatiblepasswordsv862989-NewpasswordrulesasofWebASABAP7.
0/NetWeaver2004Chapter3.
SecurityProblems47UsersAreRepeatedlyPromptedforCredentialsWhenTryingtoLogOntoanSAPNamespaceWhenuserswhoseuserIDsorpasswordscontainspecialcharacterstrytologontoanSAPnamespace,theyarerepeatedlypromptedforcredentialsandmaynotbegrantedaccess.
ThisisbecauseSAPBWsystems,version3.
5andolder,bydefaultuseanon-Unicodecodepage.
NewerSAPsystemsuseaUnicodecodepage.
Asaresult,thedefaultSAPservercodepagewasmodifiedfortheSAPauthenticationprovidertouseaUnicodecodepage,whichisSAPCP4110.
Toavoidthisissue,inIBMCognosConfiguration,modifythedefaultSAPBWServerCodePageparameterfortheSAPauthenticationprovidertouseanon-Unicodecodepage,suchasSAPCP1100.
ProblemsUsingAuthenticationProvidersThetopicsinthissectiondocumentproblemsyoumayencounterwhenusinganauthenticationprovider.
UnauthorizeduserscanrunreportsYouuseSignonsforauthenticationtocreateadatasourceconnection,whichallowsuserstousethesameusernameandpassword.
Later,youmodifytouseanexternalnamespaceinstead,suchasLDAP,andtheoriginalsignonisstillusedforauthentication.
Thishappenswhentheoriginalsignonwasusedbecausetheinformationissubsequentlystoredinthecontentstore.
AboutthistaskForexample,whenareportisindevelopmentandtesting,youcreateadatasourceconnectionusingSignonsasthemethodofauthentication.
Whenthereportgoestoproduction,youchangetheauthenticationtoanexternalnamespace.
Youthinkthatthenamespaceisbeingusedforauthenticationbutinsteadtheoriginalsignonusernameandpasswordarebeingused.
Thiscouldcreateunexpectedresultsduetoorderofpreference.
Procedure1.
LaunchIBMCognosAdministration.
2.
OntheConfigurationtab,selectDataSourceConnections.
3.
Clickthedatasourceandthenclickthedatasource.
4.
Onthenextpage,clickthedatasourceagain.
5.
Selectthecheckboxforthesignon,thenclickDelete.
ResultsThesignonisdeleted.
ExpiredPasswordErrorAppearsWhenUsingActiveDirectoryServerYouuseActiveDirectoryServerasanauthenticationprovider.
WhenyoulogontoIBMCognoscomponents,youseethefollowingerrormessage:Yourpasswordhasexpired.
Pleasechangeit.
48IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidePleasetypeyourcredentialsforauthentication.
EnsurethatyousetuptheauthorityfordelegatedadministrationforIBMCognoscomponents.
TheservernameornamedaccountforstartingtheIBMCognosservicemustbesetupintheActiveDirectoryServerasanauthorityfordelegatedadministration.
IBMCognoscomponentscanthenreadalluserpropertiesfromtheActiveDirectoryserver.
Formoreinformation,seetheActiveDirectoryServerdocumentation.
SingleSignonIsNotWorkingWhenUsingActiveDirectoryServerYouuseActiveDirectoryServerasanauthenticationproviderandsinglesignonisnotworking.
ToensurethatusersarenotpromptedtologontoIBMCognoscomponents,thefollowingmustbetrue:vActiveDirectoryisrunninginnativemode.
vTheuserdoesnothavetheAccountissensitiveandcannotbedelegatedattributeselected.
vForeachIISWebserver,thefollowingmustbetrue:–ThiscomputerispartoftheActiveDirectorydomain.
–IftheprocessisrunningasaLocalSystemAccount,theTrustcomputerfordelegationattributeisselected.
–IftheprocessisrunningasaDomainUserAccount,theAccountistrustedfordelegationattributeisselected.
vForeachIBMCognosContentManagerserver,thefollowingmustbetrue:–ThiscomputerispartoftheActiveDirectorydomain–IftheprocessisrunningasaLocalSystemAccount,theTrustcomputerfordelegationattributeisselected–IftheprocessisrunningasadomainUserAccount,theAccountistrustedfordelegationattributeisselected.
vKerberosauthenticationmustbetheactiveWWW-authenticationheader.
Note:KerberoswillnotworkinanInternetzone.
UnabletoIdentifyRequiredSAPPermissionsYoumayencountererrorsusingSAPBWbecauseyourSAPusersignondoesnothavesufficientpermissions.
Toidentifythepermissionsneeded,usetheST01transaction.
Procedure1.
InSAPR/3,type/ST01inthecommandwindow.
2.
UnderTracecomponents,selectAuthorizationcheck.
3.
SelectChangetrace.
4.
IntheOptionsforTraceAnalysisField,underGeneralRestrictions,entertheusernameoftheIBMCognosaccountyouaretracing.
Chapter3.
SecurityProblems49UnabletoAccessIBMCognosAdministrationWhenanNTLMNamespaceIsUsedandSingleSignonIsEnabledWhenyouareloggedintoIBMCognossoftwareusinganNTLMnamespaceandsinglesignonisenabledforyoursystem,anIBMCognosApplicationFirewall(CAF)errormayoccurwhenyoutrytoaccessIBMCognosAdministration.
Toavoidthisproblem,resolveanypossibleissuesrelatedtothegatewayhostname.
Youcaneitherensurethatthegatewayhostnamematchesthegatewayhostoryoucanaddthenameofthegatewayservertothelistofvaliddomainsandhosts.
MatchtheGatewayHostNameTheproceduretomatchthegatewayhostnameisasfollows.
Procedure1.
OpenIBMCognosConfiguration.
2.
IntheExplorerwindow,clickEnvironment.
3.
InthePropertieswindow,underGatewaySettings,ensurethatGatewayURIspecifiesthecorrectservernameorIPaddressandnotlocalhost.
Tip:WerecommendspecifyingaservernameorIPaddress,notlocalhost,forallURIproperties.
4.
Savetheconfiguration.
AddtheGatewayServerasaValidHostTheproceduretoaddthegatewayserverasavalidhost.
Procedure1.
OpenIBMCognosConfiguration.
2.
IntheExplorerwindow,underSecurity,clickIBMCognosApplicationFirewall.
3.
InthePropertieswindow,clicktheValuecolumnforValiddomainsorhostsandthenclicktheeditbutton.
4.
ClickAdd.
5.
TypethenameofthegatewayserverintheblankrowandthenclickOK.
Formoreinformationaboutvaliddomains,seetheInstallationandConfigurationGuide.
6.
Savetheconfiguration.
7.
RestarttheIBMCognosservice.
UnabletoAutomaticallyConnecttoanSAPBWDataSourcebySSOYouareunabletoconnecttoanSAPBWdatasource,bySSO,eventhoughitisconfiguredtouseanexternalSAPnamespaceforauthentication.
Thisproblemoccursifallofthefollowingconditionsaremet:vAnSAPnamespaceisconfiguredinIBMCognospointingtoSAPBWSystemA.
vIBMCognosusersareloggedontotheSAPnamespaceusingcredentials(ausernameandpassword),andnotthroughtheSAPPortalusingsinglesign-on.
50IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidevAdatasourcereferringtoSAPBWsystemBisdefinedandisconfiguredtouseanexternalnamespacefordatasourceauthentication.
ThenamespacereferredtoasexternalistheSAPnamespaceconfiguredforauthenticatinguserstoIBMCognoscomponents.
vSSOticketsareenabledfortheSAPBWserverassociatedwiththeSAPnamespace.
TheSAPprovidergeneratesandcachesSAPlogonticketstobeusedforauthenticationwithanSAPdatasource.
Theproviderusesthecurrentusercredentials,usernameandpassword,togenerateanSAPlogonticket.
IftheSAPBWsystemassociatedwiththedatasourcedoesnotacceptlogonticketsbecauseoftheSAPserverconfiguration,orifthelogonticketpresentedisnotvalidbecauseitoriginatesfromasysteminadifferentSAPSSOdomain,datasourceauthenticationwillfail.
Tosolvethisproblem,youcanfederatetheSAPsystemsintooneSAPSSOdomainsothattheticketgeneratedfortheuserinonesystemisvalidintheothersystemaswell.
Ifthissolutionisnotpossible,disabletheuseofSAPBWSSOticketsfortheprovidertotriggerittofallbacktopassingthecredentialsofthecurrentuserinsteadofalogonticket.
Thecredentialsmustbevalidforallsystemsaccessedasadatasource.
YoucandisableSAPSSOticketseitherontheSAPBWsystemusedasadatasource,orbyspecifyingthebapiSSOSupportparameterinthebapiint_config.
xmlfileinstalledwithIBMCognoscomponents.
Asaresult,theproviderwillusetheenteredcredentialsofthecurrentuserfordatasourceauthentication.
TodisabletheuseofSSOticketsfordatasourceauthenticationinthebapiint_config.
xmlfile,performthefollowingstepsforallIBMCognosapplicationtiercomponentsinstalledinyoursystem.
Procedure1.
StoptheIBMCognosservice.
2.
Openthebapiint_config.
xmlfile.
Thisfileislocatedintheinstall_location/configurationdirectory.
3.
SearchforthebapiSSOSupportparameterandchangeitsvalueto0,asshowninthefollowingexample:wherethedoesnotcontainanunderscore.
2.
ConfiguretheOracleContentManagerconnectioninIBMCognosConfigurationsothattheServiceNameisthesameastheinstep1.
CannotConnecttoanOLAPDataSourceYoucannotconnecttoanOLAPsource,suchasSAPBW,Essbase,orDb2OLAP.
Confirmthefollowing:vYoucanopentheOLAPserverfromMicrosoftExcel.
MostOLAPvendorshaveaplug-inwhichallowsconnectivitythroughExcel.
vYouhavethecorrectclientsoftwareinstalledontherelevantIBMCognosservers.
AnyIBMCognoscomputerwhichretrievesdatafromtheOLAPsourcemusthavetheappropriateclientsoftware.
vForMSAS,checkthatPivotTableserviceisinstalledandthecorrectservicepackisapplied.
vYoucanopentheOLAPsourcethroughIBMCognosSeries7.
vYoucanopeneithertheOLAPvendorsamplesortheIBMCognossamples.
Theproblemmaybespecifictoonemodel,outline,orcube.
vTheusermakingtherequestfromIBMCognossoftwareisaDomainuserwiththeappropriateaccessrights.
UnabletoSelectODBCastheTypeofDataSourceConnectionBecauseIBMCognossoftwareonUNIXdoesnotsupportallODBCdrivers,whenyoucreatedatasourceconnectionstoIBMRedBrick,MicrosoftSQLServer,orNCRTeradatadatabases,youcannotselectODBCasthetypeofdatasourceconnection.
TocreateanODBCconnectiontothesedatabasevendors,selectOtherTypeinstead.
54IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideForthefollowingdatabasevendors,addtheassociateddatabasecodeswhenyoutypetheconnectionstring.
Table9.
DatabasecodesusedforconnectionsstringaccordingtotheassociateddatabasevendorDatabasevendorDatabasecodeIBMRedBrickRBMicrosoftSQLServerSSNCRTeradataTDTypethedatasourceconnection,asfollows:[^UserID:[^Password:]];LOCAL;{RBSSTD};DSN=Data_Source[;UID=%s[;PWD=%s]][@ASYNC={01}][@Connection_Timeout/Reply_Timeout][@COLSEQ=[Collation_Sequence]]Thefollowingareexamplesofconnectionstrings:v^UserID:^Password:;LOCAL;RB;DSN=DB62SALES;UID=%s;PWD=%s@ASYNC=0v;LOCAL;SS;DSN=TESTSERVERTocreatedatasourceconnectionstoMicrosoftSQLServerfromUNIX,youmustusetheDataDirectODBCdriverforSQLServer.
ErrorWhenCreatingaDataSourceConnectiontoaPowerCubeWhenyoucreateadatasourceconnectiontoaPowerCubewhereboththePowerCubeandallreportserversareonUNIXorLinuxcomputers,thefollowingerrormayappear:Thefield"Windowslocation:"ismandatoryTosolvetheproblem,typeanycharactersintheWindowslocationfield.
TheUNIXorLinuxlocationmustbecorrect.
OtheradministrationproblemsThissectiondocumentsproblemsthatyoumightencounterwhenadministeringIBMCognossoftware.
RestartingServersAfterSolvingContentStoreProblemsIfthecontentstorebecomesunavailable,afterresolvingtheproblem,youmuststopandrestartIBMCognosservicestoresumeprocessing.
AnUpdateorDeleteRequestFailsWhenanypropertyofanobjectchanges,theversionpropertyassociatedwiththeobjectchanges.
Ifyoutrytoupdateordeleteanobject,therequestfailsifthevalueoftheversionpropertychangedafteryouretrievedtheobjectfromthedatastore.
Chapter4.
Administrationproblems55Forexample,iftwoadministratorsreadthepropertiesofthesameobjectatthesametime,theybothhavethesameversionoftheobject.
Iftheybothtrytoupdate,thefirstupdaterequestsucceeds.
However,thesecondupdaterequestfailsbecausetheversionoftheobjectnolongermatchestheversionretrievedfromthedatastore.
Ifthishappenswhenyousubmitanupdaterequest,youmustreadthedataagaintogetthecurrentversionoftheobjectandthenresubmityourupdaterequest.
HigherLoggingLevelsNegativelyAffectPerformanceAlltheIBMCognosservicessendeventstothelogserver,whichdirectsmessagestoalogfile.
Afteranerrororproblemoccurs,youcanreviewthelogmessagestoobtaincluesastowhathappened.
Logmessagesalsoprovidethestatusofcomponentsandahigh-levelviewofimportantevents,suchassuccessfulcompletionsandfatalerrorsIntheserveradministrationtool,fivelevelsofloggingareavailable.
Theyrangefromminimal,whichlogstheleastamountofdetailandisintendedforlessfrequentevents,tofull,whichlogsmoredetailandisintendedformorefrequenteventsanddetailedtroubleshootingpurposes.
IncreasingthelogginglevelmaynegativelyaffecttheperformanceofIBMCognossoftware.
Thehigherthelevelofdetaillogged,themoreresourcesthatareused.
Ifperformanceisslow,youcantryloweringthelogginglevels.
Toaccesstheserveradministrationtool,youmusthaveexecutepermissionsfortheAdministrationsecuredfunction.
Procedure1.
OntheConfigurationtabinIBMCognosAdministration,clickDispatchersandServices.
2.
IntheActionscolumn,clickthesetpropertiesbuttonforthedispatcherorconfigurationfolderyouwant.
3.
ClicktheSettingstabtoviewalltheconfigurationsettings.
4.
IntheValuecolumn,clickanewvalueforthefollowingsettings,eachofwhichrepresentsaloggingcategory:vAuditlogginglevelvAuditrun-timeusagelogginglevelvAuditadministrationlogginglevelvAuditotherlogginglevelTip:Ifyouwanttoresetaconfigurationsettingtoitsdefaultvalue,selectitscheckboxandclickResettoparentvalue.
5.
ClickOK.
UnabletoIdentifySAPBWVersionandCorrectionsYoumustusesupportedversionsandpatchlevelsofSAPBW,soyoumustbeabletoseealistofpatches(correctionnotes)thathavebeenapplied.
Formoreinformationaboutsupportedversions,seetheIBMSoftwareProductCompatibilityReportspage(www.
ibm.
com/support/docview.
wssuid=swg27047186).
56IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideToseealistofcorrectionnotesthathavebeenapplied,youcanrunoneoftwotransactionsinR/3:SE95,orSNOTE.
Inallcases,youmustbeauthorizedtorunthesetransactions.
Insomecases,youmayneedtorunthetransactionsusingthesameaccountthatwasusedtoapplythecorrectionnotes.
Procedure1.
InSAPR/3,type/SE95inthecommandwindow.
2.
Enteranasterisk(*)intheLastChangedByfield,toviewallnotes.
3.
SelectthetypeofmodificationintheModificationstab.
SBW-ERR-0020ErrorWhenRunningReportsBasedonSAPBWDataSourcesOccasionally,whenyourunreportsbasedonanSAPBWdatasource,thefollowingerrormessagemayappear:QueryingtheSAPBWcube'sfailed.
SAPerrorcode:BAP-ERR-0002ABAPIerrorhasoccurredinthefunctionmoduleBAPI_MDDATASET_GET_AXIS_DATA.
&INCLUDEINCL_INSTALLATION_ERRORThismessagemeansthatSAPBWhasrunoutofresources.
Inthissituation,werecommendcontactingyoursystemadministrator.
LinkstoReferencedContentObjectsareBrokenFollowingDeploymentAfteryouimportadeploymentarchivetoanewlocation,somelinksforobjectsassociatedwithreportsdonotwork.
Whenyouimportcontentobjectswhichcontainreferencestootherobjectsthatarenotinthetargetenvironment,thesereferencesareremoved.
Forexample,ifyoudeployanarchivecontainingreportsbasedonametadatapackagethatisnotinthedeploymentarchiveorthetargetenvironment,thenthelinkswillremainbrokenevenifthereferencedobjectissubsequentlycreated.
Tosolvethisproblem,dooneofthefollowing:vReimportyourdeploymentpackageafterthetargetobjectshavebeencreated.
TheobjectswillbeautomaticallylinkedvManuallyreconnectthelinkstoanobject.
TableorViewDoesnotExistforSampleDatabaseTheschemapropertyineachoftheFrameworkManagermodelsissynchronizedtorunagainsttheschemasdefinedinthesampledatabases.
Ifyouchangeanyofthedatabaseschemas,youreceiveanerrorconnectedtotheFrameworkManagermodelthatsaysthetableorviewdoesnotexist.
Tosolvetheproblem,openthemodelinFrameworkManagerandupdatetheschemanameandthenre-publishallpackages.
Chapter4.
Administrationproblems57CNC-ASV-0007ErrorWhenCallingaReportTriggerFromaWebServiceTaskWhencallingareporttriggerfromaWebservicetask,thefollowingerrormessagemayappear:CNC-ASV-0007AnerroroccurredwiththeagentWebservicetask.
Theoperationfailed.
org.
apache.
wsif.
WSIFException:CloneNotSupportedExceptioncloningcontext.
ThisproblemisrelatedtothereplacementofyourexistingJavaRuntimeEnvironment(JRE)bytotheJREusedbyIBMCognosAnalytics.
Toavoidthisproblem,modifythebootstrap_win32.
xmlfileintheinstallation_location\bindirectorybyaddingthefollowinglineofcodeforthespawnelementunder:-Xss128mJavaVirtualMachineFailsUnderLoadWhenMultipleUsersRunIBMCognosWorkspaceDashboardsUsingJRE1.
6SR6forMicrosoftWindows,thefollowingoccurs:vtheJavaPIDdisappearsvtheJavacoreisnotgeneratedvtheJava.
exedisappearsvthereisnosignofamemoryleakorhighCPUutilizationvwhenthejava.
exefails,thefollowingerrorisreportedintheMicrosoftWindowsEventViewer:Faultingapplicationjava.
exe,version6.
0.
0.
0,faultingmodulej9jit24.
dll,version2.
4.
0.
42924,faultaddress0x002ec4c2.
vboththecgsLauncherandBIBusprocessesbecomeorphansandanewJavaprocessislaunchedvnoerrorsarewrittentoIBMCognosAnalytics,version10.
1,logfilesTheworkaroundistosettheTR_DisableEBPasGPRenvironmentvariabletoTR_DisableEBPasGPR=1,beforestartingtheJavaVirtualMachine(JVM).
OracleEssbaseVersion11SubstitutionVariablesMustBeSetattheCubeLevelInIBMCognosAnalytics,forMicrosoftWindowsoperatingsystems,substitutionvariablesthatarecreatedusingtheapplicationmanagerontheOracleEssbaseservercanbeusedtoalterthecontextofareport.
Forexample,byusingsubstitutionvariables,suchascurrentmonthorcurrentquarter,youcanchangetheassignedvalueinoneplaceandtheappropriatereportsaredynamicallyupdatedwhenthereportisruninallIBMCognosstudios.
Agivensubstitutionvariablecanbesetforanentireserver,anapplication,oradatabase.
SubstitutionvariablesthatarecreatedwithOracleEssbaseversion11andintendedforusewithIBMCognosAnalyticscanonlybesetatthecubelevel(applicationordatabase).
butnotattheserverlevel.
ThefollowingDb2errormessageisdisplayedallIBMCognosstudioswhenattemptingtoloadacubethatcontainsasubstitutionvariablecreatedattheserverlevel:58IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideDB2-ERR-0033Anerroroccurredwhiletryingtoaccessthesubstitutionvariables.
Databaseerrorcode:1,051,085.
Code1051085correspondstothefollowingOracleEssbaseerrormessage:Youdonothavesufficientaccesstogetthissubstitutionvariable.
CNC-SDS-0413ErrorwhenexecutingascheduledreportWhenexecutingascheduledreport,theuserauthenticationfailswiththefollowingerrormessage:CNC-SDS-0413Thereisaprobleminexecutingthetask.
Theuserauthenticationfailed.
Itmaynotbepossibletorerunthetask.
AboutthistaskThereportfailsbecausethecredentialsareinvalid.
Invalidcredentialscanoccurwhentheuserpasswordhasexpiredorbeenaltered,ortheuseraccountisinvalid.
Whencredentialsareinvalid,thecurrentusercredentialsdonotmatchthecredentialsstoredintheContentStoredatabase.
Youcanuseajobandschedulemonitorservice(JSM)trace,previouslyknownasschedulinganddeliveryservice(SDS),tohelptraptheerrorsrelatedtothescheduledreports.
Ifthescheduleisusinganinvaliduseraccount,loginasavaliduser,schedulethereportusingthevalidaccount,andclickSave.
Theschedulewillnowusethevaliduseraccount.
Ifthecredentialsareinvalidbecausetheyhaveexpiredorhavebeenaltered,youmustrenewthecredentials.
Procedure1.
InMyPreferences,renewyourcredentials.
2.
Testfortheerror.
Youcandothisbyschedulingthereportstorunorcreatingatriggertorunthereports.
Chapter4.
Administrationproblems5960IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideChapter5.
ProblemsAuthoringReportsIBMCognosAnalytics-Reportingcanbeusedtocreatedifferenttypesofreports,includinglists,crosstabreports,charts,anduser-designedreports.
YoumayencounterproblemswhenauthoringreportsinReportingorIBMCognosQueryStudio.
ProblemsCreatingReportsPlanned,professionalreportsarecreatedinIBMCognosAnalytics-Reporting,andadhocreportsarecreatedinIBMCognosQueryStudio.
Thetopicsinthissectiondocumentproblemsyoumayencounterwhencreatingreports.
ChartLabelsOverwriteOneAnotherInIBMCognosAnalytics-ReportingandQueryStudio,ifyoudefineachartandrenderitinHTMLorPDFformatusingthedefaultsizes,theaxislabelsofthechartmayoverwriteeachother.
Toavoidthisproblem,makethechartwiderortallerbymodifyingtheheightandwidthpropertiesofthechartorenabletheAllowskipproperty.
ChartShowsOnlyEverySecondLabelYoucreateareportthatincludesachart.
TheAllowskippropertyissettofalse,butwhenyourunthereport,labelsareskipped.
ThiscanoccurifthereisnotenoughroomforalllabelsandthepropertiesAllow45°rotation,Allow90°rotation,andAllowstaggerarealsosettofalse.
IBMCognosAnalyticshasnooptionsformakingthelabelsfit,soitskipseverysecondlabel.
ThesolutionistoselecteitherAllow45°rotation,Allow90°rotation,orAllowstagger.
ChartGradientBackgroundsAppearGrayinInternetExplorerInIBMCognosAnalytics-Reporting,youcandefineacustompaletteforachartthatincludesagradient.
WhenthechartisrenderedinHTMLformatinMicrosoftInternetExplorer,thechartbackgroundappearsgray.
ThisisanInternetExplorerissue.
Toavoidthisproblem,selectthechartanddefinethecolorwhiteasthechartbackground.
Formoreinformation,seetheMicrosoftKnowledgeBasearticle#294714athttp://support.
microsoft.
com.
61DivisionbyZeroOperationAppearsDifferentlyinListsandCrosstabsIfyouhavealistthataccessesarelationaldatasource,acalculationcontainingadivisionbyzerooperationappearsasanullvalue,suchasanemptycell.
Inacrosstab,thedivisionbyzerooperationappearsas/0.
ThishappenswhenthequerypropertyAvoiddivisionbyzeroissettoYes,whichisthedefault.
Tohaveaconsistentdisplayofnullvaluesinlistsandcrosstabs,defineanif-then-elsestatementintheexpressioninthecrosstabcellthatchangesthevalue/0tothevaluenull.
ApplicationerrorappearswhenupgradingareportWhenupgradingareport,thefollowingerrorappearsifthereportcontainsdataitemsinthepagelayoutthatarenotinadatacontainer:RSV-SRV-0040Anapplicationerrorhasoccurred.
PleasecontactyourAdministrator.
ThiserroroccurswhenIBMCognosAnalyticscannotdeterminethequeryreferenceforadataitem.
Suchdataitemsareidentifiedbyaredcirclewithawhitexicon.
Tocorrecttheerror,dragthedataitemsintoacontainer.
Ifthecontainerisalist,werecommendthatyoudragthedataitemsintothelistpageheaderorfooter,ortheoverallheaderorfooter.
Ifyouwanttoseethefirstrowoftheitemoneachpageorintheoverallreport,dragtheitemtothelistpageheaderoroverallheader.
Ifyouwanttoseetheitem'slastrowoneachpageorintheoverallreport,dragtheitemtothelistpagefooteroroverallfooter.
Tip:Ifaheaderorfooterdoesnotexist,createit.
NestedListReportContainingaDataItemThatisGroupedMoreThanOnceDoesNotRunAfterUpgradeWhenyouupgradeanestedlistreportthatcontainsadataitemthatisgroupedinbothlists,thereportdoesnotrun.
Thefollowingerroroccurswhenthereportisrunagainstadimensionaldatasourceandbothlistsareusingthesamequery.
Thiserrordoesnotoccurifthereportisrunagainstarelationaldatasource.
OP-ERR-0199:Thequeryisnotsupported.
Thedimensionsontheedgeareinconsistent.
ThedataItemsfromdimension="[Productline]"mustbeadjacent.
Forexample,youhavealistthatcontainsthegroupeditemsProductlineandProducttypeandanestedlistthatcontainsthedataitemsYear,Quarter,Productline,andUnitsaleprice.
Year,Quarter,andProductlinearegroupeditemsinthenestedlist.
Toresolvetheissue,deletethedataitemthatisgroupedinbothlistsfromtheinnerlist.
Procedure1.
Clickanywhereinthereport.
62IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuide2.
ClicktheShowpropertiesicon,andInthePropertiespane,clicktheSelectancestoriconandclicktheListlinkthatrepresentstheinnerlist.
3.
Double-clicktheGrouping&sortingproperty.
4.
IntheGroupspane,selectthedataitemthatyouwantandpresstheDeletekey.
BackgroundColorinTemplateDoesnotAppearWhencreatingaQueryStudiotemplateinIBMCognosAnalytics-Reporting,ifyouaddalistobjectandchangeitsbackgroundcolor,thecolorchangedoesnotappearwhenyouapplythetemplatetoaQueryStudioreport.
Toworkaroundthisissue,dooneofthefollowing:vEditthestylesheet(CSS)classesforlistsinCognosAnalytics-Reporting.
vDonotaddanyobjectstothepagebodywhenyouarecreatingaQueryStudiotemplate.
vLeavethepagebodyblank.
SubtotalsinGroupedListsWhenusinganIBMCognosPowerCubethatcontainsaraggedhierarchy,ifyougrouponthefirstlevelinthehierarchy,subtotalsmayappearinthewrongplaceorshowwrongvalues.
Toresolvetheissue,grouponthesecondlevel.
MetadataChangeinOracleEssbaseNotReflectedinReportsandintheStudiosWhenthereisametadatachangeontheOracleEssbaseserver,thechangeisnotimmediatelyreflectedinthemetadatatreeinthestudios.
Inaddition,whenareportisrun,thereportdoesnotpickuptherepublishedchanges.
Toviewthenewstructure,youmustrestarttheIBMCognosContentManagerserver.
RelationshipsNotMaintainedinaReportWithOverlappingSetLevelsInareport,therelationshipbetweennestedorparallelmembersetsatoverlappinglevelsinthesamedimensionmaynotalwaysbemaintained.
Forexample,anamedsetinthedatasourcethatcontainsmembersfrombothaYearandMonthmemberisnestedunderYear,butisnotproperlygroupedbyyear.
Inanotherexample,anerrormessagesuchasthisappears:OP-ERR-0201Valuescannotbecomputedcorrectlyinthepresenceofmultiplehierarchies([Product].
[B1],[Product].
[Product])thateachhavealevelbasedonthesameattribute(Product).
Thisproblemoccursinthefollowingscenariosinvolvingnon-measuredataitemsXandY,whichoverlapinthesamedimension:vXandYtogetherasungroupedreportdetailsChapter5.
ProblemsAuthoringReports63vYnestedunderXvYappendedasanattributeofagroupbasedonXWhenusingnamedsets,orsetsthatcovermorethanonelevelofahierarchy,donotusesetsfromthesamedimensioninmorethanoneplaceinthesamereport.
Theyshouldappearononlyonelevelofoneedge.
CreatingSectionsonReportsThatAccessSAPBWDataSourcesSAPBWdatasourcesmayhaveproblemswithsectionsinreportsunderdifferentcircumstances:Ifasectioninareportusesthelowest-levelqueryiteminaraggedhierarchy,suchasthechildrenofthenotassignednode,thefollowingBAPIerrormayappear:BAPIerroroccurredinfunctionmoduleBAPI_MDDATASET_SELECT_DATA.
ValueforcharacteristicunknownFormoreinformationaboutworkingwithraggedorunbalancedhierarchies,seetheIBMCognosAnalytics-ReportingUserGuide.
Lowest-levelQueryIteminaRaggedHierarchyThesolutionistoremovethesectionfromthelowest-levelqueryitem.
SeveralMulticubeswithSAPVariablesThesolutionistouseoneSAPmulticubewhencreatingsectionsinreports.
ErrorCharacters(--)AppearinReportsWhenyourunareport,youseetwodash(--)charactersinyourreportinsteadofvalues.
ThesecharactersmayappearifyouuseanOLAPdatasourcesotherthanPowerCubeandMicrosoftSQLServer2005AnalysisServices(SSAS),andyouapplyaggregationtocalculationsandmeasuresthatuserollupsotherthanSum(Total),Maximum,Minimum,First,Last,andCount.
Allothertypesofrollupeitherfailorreturnerrorcells,whichtypicallydisplayastwodashcharacters(--).
Thisproblemoccursin,butisnotlimitedto,thefollowing:vfootersvaggregatefunctionvsummaryfiltersanddetailfiltersthatuseasummaryvdetail,summary,andcontextfiltersthatselectmorethanonememberofahierarchythatisusedelsewhereonthereportIfyouareworkingwithaSSAS2005datasource,thesecharactersmayalsoappearinsummarycellsifyouuseanORfilterinthesummary.
Toavoidthisproblem,donotuseORfiltersinsummaries.
64IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideFunctionUnreliablewithSetsIfyoucreateanexpressionthatusesthedescendantsfunctionwithsets,youmayencounterunpredictableresults.
Someexpectedmembersmaybemissingormayhaveblankcaptionsorlabels.
Thisproblemoccursifthedescendantsfunctionusesasetasitsfirstparameterinsteadofasinglememberandifthedescendantsfunctionisnestedunderanotherdataitemfromthesamehierarchy.
Toavoidthisproblem,replacethefirstparameterinthedescendantsfunctionwiththefunctioncurrentmember(H),whereHisthehierarchyofthedesiredsetandunderwhichtheexpressionisnested.
Forexample,usedescendants(currentmember(H).
Columns,Rows,orDataDisappearWithSSAS2005CubesMicrosoftSQLServer2005AnalysisServices(SSAS)hasafeaturecalledAutoExiststhatremovestuplesthathavenofactsattheintersectionoftwohierarchiesofthesamedimension.
Columns,rows,ordatacandisappearifyousetthedefaultmemberofahierarchytoamemberthatdoesnotexistwitheveryothermemberinthedimension.
Toavoidthisproblem,changethedefaultmemberthatcausedthedisappearancetoamemberthatexistswithallothermembersinthedimension.
Columns,rows,ordatacanalsodisappearifmembersarespecifiedthatresultinoneormorenon-existenttuples.
Thereiscurrentlynoworkaroundforthisscenario.
Formoreinformation,seeMicrosoftKnowledgeBasearticle#944527athttp://support.
microsoft.
com.
Youmayalsoencounterunexpectedresultsifthedefaultmemberofahierarchyisamemberthatdoesn'talsoexistinallotherhierarchiesinthedimension,andifyouquerymembersfromdifferenthierarchiesinthesamedimension.
Forexampleacrosstabincludesthefollowing(usingtheAdventureWorkscube):vRows:Generate([Adventure_Works].
[Account].
[Accounts],set([BalanceSheet],[Units]))nestedwithchildren([Adventure_Works].
[Department].
[Departments]->:[YK].
[[Department]].
[Departments]].
&[1]]])vColumn:[Adventure_Works].
[Account].
[AccountNumber].
[AccountNumber]vMeasure:[Adventure_Works].
[Measures].
[Amount]Yourunthereportandnoticethatthequeryrenderswithsomeblankscells.
Youthenapplythesimpledetailfilter[Amount]>1andrunthereport.
Onlyrowlabelsaredisplayedandalldataandcolumnsaremissing.
IntheAdventureWorkscube,the[Account].
[Accounts]attributehasadefaultmembersetto[NetIncome].
WhenevaluatingtheGENERATEsetexpression,SSASlooksintheentirecubespaceandlooksatallcoordinatesforthe[Account]dimension.
Thesecoordinatesincludeboth[Account][AccountType].
&[]and[Account].
[Accounts].
[NetIncome].
Becausethesetwocoordinatesdon'texistwithinthesamehierarchy,SSASreturnsanemptyset.
ToavoidthisproblemtheSSASadministratormustsetthedefaultmemberinthecubetoamemberthatexistsinallotherhierarchies.
Chapter5.
ProblemsAuthoringReports65UnexpectedCellFormattinginReportsWhenusingdatasourcesotherthanOLAPandyourunareport,cellformattingmaynotappearasexpected.
Forexample,somecellsmayappearverysmall.
Thiscouldbecausedbynullvaluesreturnedfromthequery.
Tospecifywhatappearsforadatacontainerwhentherearenullvaluesinaquery,refertotheIBMCognosAnalytics-ReportingUserGuide.
YoumayalsoseeanInvalidDatesmessageinsomecells.
ThisissueisspecifictoTransformerandoccurswhencubesareconstructedwithunknowndatevalues.
Formoreinformation,seetheIBMCognosTransformerUserGuide.
ReportDifferencesBetweenTM1ExecutiveViewerandIBMCognosAnalyticswithTM1DataSourcesWhenusinganIBMCognosTM1datasource,comparablereportscreatedinIBMCognosAnalyticsandinTM1ExecutiveViewermaycontaindifferentcellvalues.
ThisoccursbecausetheTM1ExecutiveViewerproductusesanalgorithmforselectingdefaultmembersfornon-projecteddimensionsthatdiffersslightlyfromtraditionalOLAPclients.
Toavoidthisproblem,whenfilteringyourreportsinIBMCognosAnalytics,usecontextfiltersthatmatchthedefaultselectionsshownintheExecutiveVieweruserinterface.
ThisensuresthatthecellvaluesinIBMCognosAnalyticsmatchthevaluesinExecutiveViewer.
OrderofMetadataTreeDiffersforTM1DataSourcesWhenusingaanIBMCognosTM1datasource,theorderofmembersinthemetadatatreeoftheSourcetabinIBMCognosAnalyticsmaydifferfromtheordershowninTM1Architect.
Bydefault,TM1ArchitectrendersmembersofhierarchiesusingaslightlydifferentalgorithmthandoesIBMCognosAnalytics.
IBMCognosAnalyticsautomaticallyrendersmembermetadatafromTM1datasourcesinhierarchicalorder.
FromwithinTM1Architect,ifyouwanttoseehowIBMCognosAnalyticswillrenderahierarchy,clicktheHierarchySortbutton.
MSR-PD-0012errorwhenimportingexternaldataWhenyoutrytoimportanexternaldatafile,youreceiveanMSR-PD-0012error.
MSR-PD-0012:Unabletouploadthespecifiedexternaldatafile.
Itexceedsthepermittedfilesizeof"0(KB)",asspecifiedbyyoursystemadministrator.
ThiserroroccurswhenthesizeofthefileyouaretryingtoimportisgreaterthanthevaluespecifiedfortheMaximumexternaldatafilesize(KB)governorintheFrameworkManagermodel.
Toresolvetheissue,themodelermustupdatethegovernor,savethemodel,andrepublishthepackage.
MSR-PD-0013errorwhenimportingexternaldataWhenyoutrytoimportanexternaldatafile,youreceiveanMSR-PD-0013error.
66IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideMSR-PD-0013:Unabletouploadthespecifiedexternaldatafile.
Itexceedsthepermittedmaximumnumberofrows"0",asspecifiedbyyoursystemadministrator.
ThiserroroccurswhenthenumberoflinesinthefileyouaretryingtoimportisgreaterthanthevaluespecifiedfortheMaximumexternaldatarowcountgovernorintheFrameworkManagermodel.
Toresolvetheissue,themodelermustupdatethegovernor,savethemodel,andrepublishthepackage.
ProblemsCalculatingDataThetopicsinthissectiondocumentproblemsyoumayencounterwhenusingexpressionstocalculatedataorwhenaggregatingdatainyourreports.
SummariesinQueryCalculationsIncludeNullswithSAPBWDataSourcesWhenusinganSAPBWdatasourceinIBMCognosAnalytics-Reporting,nullvaluesinthedatabasearereturnedintheresultsetandthecountsummaryfunctionincludestheemptycellsinthefollowingscenarios:vAquerycalculationincludesanarithmeticcalculationwhereoneormoreNULLoperandsandanaggregationisperformedonthecalculation.
vTheresultofaquerycalculationisaconstant,suchascurrent_timeandcurrent_date.
Thecountsummaryfunctionshouldnormallyexcludenullvalues.
Toavoidthisproblem,forthefirstscenario,ensurethatbothoperandsdonotreturnnullvalues.
Forexample,theoriginalexpressionis[num1]+[num2].
Instead,usethefollowingexpression:if([num1]isnull)then(0)else([num1])if([num2]isnull)then(0)else([num2])Thereisnoworkaroundforthesecondscenario.
NullResultsforCalculationsUsingSAPBWDataSourcesWhenusingaSAPBWdatasource,theexpressionyouuseinyourcalculationisevaluatedasanullvalueifyourexpressioncontainsanullitem.
Forexample,inthecalculationsome_expression=result,theresultisnullifaroworcolumnthattheexpressionreferencesincludesanullvalue.
Toavoidobtainingnullvaluesastheresultofyourcalculations,suppressnullvaluesbeforeyoucreatethecalculation.
UnexpectedSummaryValuesinNestedSetsIfareportcontainsnestedsets,summariesotherthantheinnersetsummariesmaycontainunexpectedvalues.
Forexample,youinsertasummaryinacrosstabthatcontainsasetwithyearsintherows.
Chapter5.
ProblemsAuthoringReports67Youthennestaproductlinesetwithinyears.
Noticethatthesummaryvaluedoesnotchangetorepresentthetotalofthenewvalues.
Thisoccursbecausethewithinsetaggregationusedwithdimensionalpackagesdoesnottakeintoaccountsetsthatarenestedbelowthesetthatissummarized.
Toshowthecorrectsummaryvalues,iftheinnerandoutersetsdonotbelongtothesamedimension,youcannestacopyoftheinnersummaryitemundertheoutersummaryitem,asfollows.
IncorrectResultsinSummariesWhenUsingOLAPDataSourcesWhenusinganOLAPdatasource,summariesthatuseforclausesgiveincorrectresults.
Thisoccursbecauseforclausesrequireaccesstothedetailrowsofthefacttable.
OLAPdatasourcesdonothavedetailrows.
Forexample,thisreportusesadimensionally-modeledrelational(DMR)datasourceandcontainsthefollowingsummaries:vmx:maximum([Revenue]for[Year(shipdate)])vmx2:maximum(Aggregate([Revenue])for[Year(shipdate)])Figure1.
Exampleofrevenuenumbersfortheyears2012and2013Figure2.
Exampleofrevenuenumbersforthelistedproductsfortheyears2012and2013Figure3.
Exampleofthecombinedaggregatesetfortheyears2012and201368IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideNoticethatthemxandmx2valuesaredifferent,wheremx2isbasedonvisibledata,butmxisnot.
Thisresultiscorrect.
ThefollowingreportusesanOLAPdatasourceandcontainsthesamesummaries.
Figure4.
Examplelistreportthatusesadimensionally-modeledrelationaldatasourceandrevenueforfouryearsChapter5.
ProblemsAuthoringReports69Intheexamplereport,mxandmx2valuesarenowthesame.
Bothsummariesarebasedonvisibledata.
Themxvalueisincorrect.
Incorrectresultsalsoappearforfootersummaries.
Toavoidthisproblem,whenusingOLAPdatasources,ensurethattheparameterthatprecedestheforclauseisanaggregatefunction.
IncorrectResultswithIBMCognosPowerCubesandTimeMeasuresIfareportusesanIBMCognosPowerCubedatasourceandacombinationofdataitems,youwillencounterincorrectresults.
ThefollowingcombinationofdataitemsinareportthatusesanIBMCognosPowerCubedatasourcewillgiveincorrectresults.
vameasurewithaTimeStateRollupsettoAverageorWeightedAveragevanaggregate(membersfromtimedimension)expressionvanintersectionwithamemberinarelativetimehierarchyToavoidincorrectresults,donotusethiscombinationinyourreports.
UnexplainedDiscrepanciesinNumberCalculationsYoumightfindunexplaineddiscrepanciesinnumbercalculationsduetoround-offerrors.
Figure5.
Examplelistreportthatusesadimensionaldatasourceandrevenueforfouryears70IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideForexample:vYourunregressiontestsandfinddifferencesinnumbers.
Theyaredifferentonlybecauseoftheroundingoffofdecimalplaces.
vYouchoosenotdisplayzerosinreports,butthezerosaredisplayedanywaybecausetherearedecimalplaces(0.
00000000000000426,forexample)thatareroundedofftozeroinreports.
Round-offproblemsarenotspecifictoIBMCognossoftware.
Theycanoccurinanyenvironmentwhereroundingoffoccurs.
BinaryRound-OffErrorsDiscrepanciesincalculationsmightoccurduetobinaryround-offerrors.
Forexample,ifthenumber1.
1isrepresentedasabinaryfloatingpointnumberandyourreportformatincludesalargenumberofdecimalplaces,thenumber1.
1mightactuallybesomethinglike1.
09999999999997.
Ifyourreportisformattedtouseonlyonedecimalpoint,decimalround-offtakesplace,compensatingforthebinaryround-off.
Sothenumberappearstobe1.
1whenitisreally1.
09999999999997.
Whenthenumberisusedincalculations,youmightgetround-offerrors.
Forexample,MicrosoftExcelcalculationsusebinarynumbers(withoutroundingoffdecimalplaces)butformattinginreportsshowsroundedoffdecimalplaces,whichcancreatesmalldiscrepancies.
DivisionRound-OffErrorsCalculationsthatinvolvedivisiontypicallyincurround-offerrors,regardlessofhowthenumbersarerepresented.
ExamplesofsuchcalculationsareAverageandPercentofBase.
DesignGuidelinestoMinimizeRound-OffEffectThebestsolutionistochangetheunderlyingdatabaseschemaorcubemodelbutthatmaynotalwaysbepossible.
Anothersolutionistominimizetheround-offeffectbyfollowingtheseguidelineswhenauthoringreportsandcreatingmodelsinIBMCognosFrameworkManagerandexternalOLAPcubes:vAvoidstoringdatainfloatingpointformatwheneverpossible.
Thisisespeciallytrueforcurrencyvalues,whichshouldbestoredaseitherfixed-pointdecimalsorasintegerswithascalevaluesuchas2.
Forexample,inacube,theRevenueforCampingEquipmentin2012is$20,471,328.
88.
Ifrevenuedetailsarestoredasfloatingpointnumbers,round-offerrorsmightoccurwhenrevenueiscalculated.
Therounduperrorsmighthaveslightdifferences,dependingontheorderofcalculation.
IfrevenueforProductsiscalculatedfirstandrevenueforTimeiscalculatedsecond,youmightgetadifferentround-offerrorthanifTimeiscalculatedfirstandProductsiscalculatedsecond.
Totalrevenuemightbecalculatedasthenumbershowninthepreviousexample.
Ortheremightbeslightdiscrepancies,forexample,$20,471,328.
8800001asopposedto$20,471,328.
88.
Theinternalnumbermightbeslightlydifferentthanwhatisdisplayed.
Thenumbermightevenbefordifferentrunsofthesamereport,dependingontheorderthattheOLAPengineusesforcalculation.
Chapter5.
ProblemsAuthoringReports71vInreports,avoiddivisionwheneverpossible.
Whendivisionisunavoidable,trytodoitaslateaspossibleinthecalculationprocess.
Forexample,insteadofTotal([Revenue]/1000),useTotal([Revenue])/1000.
vWhendoingcomparisons,addamargintoallowforround-off.
Forexample,youmaywant[Profit%]tobeafractionalvalueformattedasapercentagewithnodecimals.
However,thefilter[Profit%]0(or[Profit%]NOTBETWEEN0and0)rejectszerovaluesandmaystillreturnvaluesthatappeartobe0%afterformatting.
Toavoidthis,filterinoneofthesetwoways:–[Profit%]NOTBETWEEN-0.
005and0.
005–([Profit%]0.
005)Notethat0.
005isequivalentto0.
5%,whichdisplaysaseither0%or1%,dependingonfloatingpointprecisionlosses.
Insomecases,youmayprefercontrolround-offerrorsbyroundingvaluesexplicitly.
Forexample,insteadof[Profit%],useround([Profit%],2).
vRecalculatenumberseverytimeinsteadofreusingcalculationsthatmightcontainroundedoffdecimals.
TheremightbeadditionalconsiderationsforMicrosoftAnalysisServices2005/2008,especiallywhencomparingreportresultsfromdifferentruns(ashappensinLifecycleManager).
RefertoMicrosoftdocumentationformoreinformation.
Errorwhenfilteringona_make_timestampcolumnYoucannotfilterona_make_timestampcolumn.
Ifyoudothat,thefollowingerrormessagesappear:UDA-SQL-0114Thecursorsuppliedtotheoperation"sqlOpenResult"isinactiveUDA-SQL-0206TheOLEDBdriverreturnedthefollowingvalue:HRESULT=DB_E_CANTCONVERTVALUERSV-SRV-0025UnabletoexecutethisrequestThesolutionistoapplythefilterafteraggregation,andnotbefore.
ProblemsDistributingReportsThetopicsinthissectiondocumentproblemsyoumayencounterwhendistributingreports.
AReportLinkinanEmailNotificationDoesNotWorkIfareportlinkinanemailnotificationdoesnotwork,theGatewayURImaynotbeconfiguredcorrectly.
YoumustchangethehostnameportionoftheGatewayURIfromlocalhosttoeithertheIPaddressofthecomputerorthecomputername.
IftheURLintheemailcontainslocalhost,remoteuserscannotopenthereport.
ReportContainsNoDataInIBMCognosEventStudio,ifanagentrunningagainstadimensionally-modeleddatasourcepassesvaluestoareportbaseduponarelationalsource,thereportmaycontainnodata.
72IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideWhenthesourceisdimensional,theagentpassesmemberuniquenames(MUNs)tothetargetreport.
Ifthetargetreportisbaseduponthesamedimensionalsource,thereportrunscorrectly.
However,ifthereportisbaseduponarelationalsource,theagentmustpassvalues(notMUNs)forthereporttoruncorrectly.
Procedure1.
DragthedataitemfromtheInsertableObjectstreetotheValuefieldinthereporttaskpage.
2.
Clickinthefield.
3.
FromtheInsertmenu,clickCaption.
HyperlinksinEmailMessagesAreStrippedOutWhentheAgentisSavedInEventStudio,hyperlinksarestrippedoutwhentheagentissaved.
Theadministratormustallowemaillinkstoensurethatthelinksremaininemailscreatedbyagents.
Procedure1.
Toallowlinksinanemail,dothefollowing:vAddthefollowinglinetotemplates/ps/portal/system.
xml:truevRestarttheserver.
Note:Addingthissettingdoesnotfixexistingagents.
2.
Toinsertalinkinanemail,dothefollowing:vHighlightsometextintheemail.
vPressCtrl-K.
vEnteraURLintotheboxthatappears.
ErrorsWhenRunningWebServiceTasksWhenrunningaWebservicetask,youmightencountererrors.
YoumustmodifyonethefollowingfilestoaddtheThreadStackSize(Xss)parameter:vbootstrap_win32.
xmlinthebinfolderfora32-bitinstallationvbootstrap_win64.
xmlinthebin64folderfora64-bitinstallationAddingthisparameterpreventstheseerrors:CNC-ASV-0001TheFollowingAgentServiceGeneralErrorOccurred:java.
lang.
StackOverflowErrorCNC-ASV-0007AnerroroccurredwiththeagentWebservicetask.
Procedure1.
Opentheappropriateversionoftheinstall_location\bin\bootstrap_win.
xmlfileinanXMLeditor.
2.
Addthefollowingtextfortheparameter(showninbold)exactlyasshownhere:Chapter5.
ProblemsAuthoringReports73.
.
.
-XX:NewSize=${dispatcherMaxMemoryBy4}m-XX.
.
.
-XX:MaxPermSize=512m-Xss512mThemaximumstacksize(Xss)parameterissetto512MBtoavoidanoverflowexceptionerror.
CannotCalltheSDKfromEventStudioEventhoughIBMCognosEventStudiohasafeaturetoinsertawebserviceasatask,itisnotpossibletocalltheIBMCognosSDKwebservice.
DuetothecomplexityoftheSDKandcomplexdatatypesandoptions,thewebservicefeatureinEventStudiodoesnothandletheIBMCognosSDK.
TheexceptiontothisruleisthetriggercommandthatcanbecalledfromEventStudio.
74IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideChapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalysesYoumayencounterproblemswhenrunning,viewing,orprintingreports.
ProblemsRunningReportsandAnalysesThetopicsinthissectiondocumentproblemsyoumayencounterwhenrunningreports.
SummariesinareportdonotcorrespondtothevisiblemembersIfacrosstaborchartcreatedinIBMCognosAnalytics-Reportingusingadimensionaldatasourcehasacontext-dependentsetfunctionsuchasfilterortopCountonanedge,summariesdonotcorrespondtothevisiblemembers.
ThisproblemoccursbecauseasummarythathasthequerypropertyUsesetaggregationsettoYes,whichproducesanexpressionthatcontainsthewithinsetclause,usesasetthatisdependentonthemembersthatitintersectswithontheoppositeedge.
Forexample,thefollowingcrosstabhasthetopthreeproductsreturnedascolumns.
TheexpressionusedtogeneratethecolumnsistopCount([Product],3,[Returnquantity])where[Product]isthelevel.
ThesummaryvaluesforTotalandMinimumforallrowsexceptCentralEuropedonotcorrespondtothemembervaluesinthecrosstab.
ThismeansthatthetopthreeproductsreturnedinallregionsexceptforCentralEuropearenotBugShieldLotion,BugShieldExtreme,andSunShelter30.
NotethatthesummaryvaluesforTotalandMinimumforallcolumnsdocorrespondtothevisiblemembervalues.
Thatisbecausethosesummaryvaluesrepresentthetotalandminimumquantitiesreturnedforthosethreeproductsineachregion.
Figure6.
Acrosstabshowingthatthesummaryvaluesforallrowsdonotcorrespondtothevisiblemembers.
75Youcanseewhatthetopthreeproductsreturnedineachregionarebydraggingthecolumnstotherightoftherows.
Toobtainsummaryvaluesthatreflectthevisiblemembers,modifytheexpressionofthedataitemcontainingthecontext-dependentsetfunctionsothatitincludesatuplethatislockedtothedefaultmemberofeveryhierarchythatappearsontheoppositeedge.
Forthisexample,modifytheexpressiontothefollowing:topCount([Product],3,tuple([Returnquantity],defaultMember([Retailersite])))where[Product]istheleveland[Retailersite]isthehierarchy.
Whenyourunthereport,allsummaryvaluesreflectthevisiblemembersinthecrosstab.
Figure7.
Asingle-edgecrosstabshowingtheTotalReturnedProductsandMinimumReturnedProductsforeachregion76IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideUnexpectedResultsforAnalysisStudioReportsUsingSuppressionandNestedRowsInIBMCognosViewer,yourunanIBMCognosAnalysisStudioreportforwhichpagebreakshavebeenset.
Detailitemsappearonlyonthepagethatcontainstheitemforwhichsuppressionisapplied,andonlysummaryitemsappearonallotherpages.
Thismayoccurbecauseofthefollowingcombinedconditions:vThereportcontainsnestedlevels.
vSuppressionisappliedtoanitemnestedinsidetheoutermostgroup.
vInthereportoptions,thepagebreakssettingisappliedtotheoutermostgroupsonrows.
Toavoidthisresult,inAnalysisStudioyoucandooneofthefollowing:vInthereportoptions,clearthepagebreakssetting.
vMovetheoutermostgrouptothecontextfilterareabeforeapplyingsuppression.
vRemoveallsuppression.
Youcanalsorunthereportasis.
Topreventthismessagefromappearing,fromtheRunmenu,clickReportOptions.
OntheDisplaytab,clearthecheckboxunderWarningpage.
IfyoudonothaveaccesstoAnalysisStudio,contactyouradministrator.
DefiningLanguagesforOLAPDataSourcesThefirsttimeyoupublishacubedefinition,youmustidentifyallthelanguagesthatrepresentthedatacontainedinthecube.
Ifyouaddalanguagetothemodelafterthecubeispublished,userswithlocalesthatmatchtheaddedlanguagelocalemayfindthatAnalysisStudiodoesnotrecognizereferencestothememberuniquenames.
Thereisnoimpactonuserswhoselocalematchestheoriginallanguagelist.
CrosstabShowsPercentageButChartShowsValuesWhenthecrosstabcalculatesthepercentageofthetotalforanitem,thechartdoesnotshowthevaluesasapercentage.
Figure8.
AcrosstabshowingthereturnquantityofproductsindifferentregionsoftheworldChapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses77CannotDrillwhenCaptionRepresentsaBlankoraZero-lengthStringAdimensionalmodeloverrelationaldatamayreturnazerolengthorblankcaptionintheroworcolumninAnalysisStudio.
Whenitdoes,youcannotdrillupordownfromthesetbecausenolinkappears.
Ifthisoccurs,youcanright-clickthecaptionandselectDrillUporDrillDownintheshortcutmenu.
DPR-ERR-2082TheCompleteErrorHasBeenLoggedbyCAFWithSecureErrorIDYoucannotrunareport.
Thefollowingerrormessagesappear:DPR-ERR-2082Anerrorhasoccurred.
Pleasecontactyouradministrator.
ThecompleteerrorhasbeenloggedbyCAFwithSecureErrorID:timestamp-#number.
RSV-DR-0002Unabletoexecutethisrequest.
TheseerrormessagesdonotindicateanIBMCognosApplicationFirewallproblem.
Youcanviewamoredetailederrormessage,inthec8server.
logfilethatresidesinthelogsdirectoryontheIBMCognosAnalyticsserver.
Procedure1.
Openthecogaudit.
logfileintheinstall_location\logsdirectoryontheIBMCognosAnalyticsserver.
2.
SearchforSecureErrororthetimestamp-errornumbercombinationshownintheerrormessage,suchas2004-06-29-15:15:03.
796-#8.
3.
TheerrormessageisundertheSecureErrorIDheading.
QueryStudioDoesNotGenerateaSELECTDISTINCTstatementifaColumnisAliasedWithoutUsingtheActualColumnNameWhenfilteringonacolumnname,thequerydoesnotgenerateaSELECTDISTINCTstatementifthereferencedcolumnisaliasedbymanuallytypingthealiasintheSQLofthequerysubject.
Toavoidthissituation,donotmanuallytypethealias.
Instead,inIBMCognosFrameworkManager,renamethecolumnbyright-clickingonitandselectingtheRenameoption.
QE-DEF-0288CannotFindtheDatabaseintheContentStoreYoucannotretrievedatafromtheselecteddatabasewhenrunningareport.
Thefollowingerrormessageappears:QE-DEF-0288Unabletofindthedatabase.
.
.
78IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideIfthiserrordoesnotoccurwhenyouareloggedonasanadministrator,thentosolvetheproblem,ensurethattheuserhaspermissionstothesignonembedded.
Ifthiserroralwaysoccurs,thedatasourcehasnotbeencreated.
Createthedatasourcewiththenamementionedintheerrormessage.
ParseErrorsWhenOpeningorRunninganUpgradedReportEarlierversionsofIBMCognosReportNetandIBMCognosBusinessIntelligenceincludedthecast_DatefunctionforreportsthatrunonanOracledatabase.
ThisfunctiondoesnotexistforOracleinIBMCognos8.
1.
2MR1andlaterversions.
IfareportthatusesanOracledatabaseincludesthecast_Datefunction,parseerrorswillbereceivedwhenyoutrytoopenorrunthereport.
OverflowErrorOccursWhenaValueinaCrosstabIsMoreThan19CharactersInacrosstabreport,valuessupportamaximumof19characters,includingthedecimalpoint.
Ifavalueexceeds19digits,anoverflowerroroccurs.
Bydefault,thedecimalprecisionissetto7digits,whichrestrictsthenumberofintegersto11digits.
Tousemorethan11integers,youmustedittheqfs_config.
xmlfileintheinstall_location\configurationdirectory.
IBMCognosAnalyticsRunsOutofTEMPSpaceBydefault,IBMCognosAnalyticsstorestemporaryfilesintheinstall_location/tempdirectory.
Theamountofspacerequiredbythetemporaryfilesdirectorydependsuponseveralfactors,includingthenumberandtypeofreportscreated.
Thefollowingerrormessageindicatesthatthetemporaryfilesdirectoryranoutofspace:QE-DEF-0177Anerroroccurredwhileperformingoperation'sqlOpenResult'.
UDA-SQL-0114Thecursorsuppliedtotheoperation"sqlOpenResult"isinactive.
UDA-TBL-0004TherewasaWriteerrorwhileprocessingatemporaryfile.
Ifthiserroroccurs,ensurethatthediskonwhichthetemporaryfilesdirectoryislocatedhasadequatespace.
Youshouldalsoperiodicallydeleteunwantedfilesfromthisdirectory.
AReportDoesNotRunasExpectedAreportmaynotrunasexpectedifthemodelcontainserrorsorthewronggovernorsettings.
Procedure1.
OpenthemodelinFrameworkManager.
2.
Ensuregovernorsaresettodisallow.
3.
Inthediagramview,ensurethattherearenocross-joinerrorsorambiguousjoins.
4.
Checkthepackageforamissingquerysubject.
5.
RuntheVerifyModelfunction,andcorrectanyerrorsdetected.
Chapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses79PerformanceIssueswhenShowingMultipleAttributesUsingDimensionally-modeledRelationalDataSourcesIfyoudisplaymultipleattributesfortheitemsinasetonthecrosstab,youcanonlyselectoneattributeatatime,soAnalysisStudioexecutesaqueryforeachattributeselection.
Theperformanceofthisapproachisanexpensiveonetoexecuteagainstarelationaldatasourcebecauseofthequerynecessarytoretrievetheattributeanditsvalue.
YoucanselectmultipleattributesforaselectedcrosstabsetinAnalysisStudiobyusingthePropertiespane.
ByselectingmultipleattributesbeforeclickingOKorApplyinthedialogbox,onlyasinglequeryforallselectedattributesisexecuted,insteadofoneperattribute.
MultipleselectionintheUIisthepreferredapproachforenablingthedisplayofmorethanoneattributefordimensionallymodeledrelationaldatasourcepackages,becauseofthereducedperformanceimpactontherelationaldatasource.
ErrorOccursinJapaneseInternetExplorer7WhenRunninganExcelReportinAnalysisStudioAnerrormayoccurwhenyoucloseJapaneseMicrosoftInternetExplorer7installedonMicrosoftWindowsXPSP2whileitisrunninganAnalysisStudioreportinExcelformat.
Tosolvethisproblem,Microsoftrecommendsthatyouunregisterthemsctf.
dllfileusingthefollowingcommand:Regsvr32/UMsctf.
dllThis.
dllfileispartofthectfmon.
exespeechrecognitionapplication.
Youmayturnoffanyspeechrecognitionapplicationinstalledonyourcomputerbeforeunregisteringthe.
dllfile.
Formoreinformationaboutturningoffspeechrecognition,seeMicrosoftKnowledgeBasearticle313176.
TheORA-00907ErrorAppearsWhenRunningaReportWhenusinganOracle9.
2datasource,undercertaincircumstances,multipleornestedjoinoperationsmayfailandproducethefollowingerror.
ORA-00907:missingrightparenthesisAquerythatusesbothaleftouterjoinandanONclauseconditionreturnszerovaluesinsteadofnullvalues.
ScheduledReportsFailYouschedulereportsthatpreviouslyransuccessfully,butnowfail.
Thefollowingerrormessageappearswhenthereportsfail:CAM.
AAAErrorauthenticatinguserThismayhappenbecauseauserchangedapassword.
IBMCognosAnalyticsusesacopyoftheuserIDandpasswordtorunthescheduledreport.
80IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideThesolutionisfortheusertorenewtheircredentials.
ProcedureFromMyPreferences,renewyourcredentials.
ThisoptionisnotavailabletousersfromanIBMCognosSeries7namespace.
TheTableorViewWasNotFoundintheDictionaryWhenyourunareport,thefollowingerrormessageappears:Thetableorview"xxx"wasnotfoundinthedictionary.
Thismayoccurifpermissionswerenotproperlyset.
EnsurethattheuserdefinedinthedatasourcehasSELECTprivilegesfortheaffectedtable.
MixedLanguagesAreDisplayedWhenUsingSamplesWhenyouselectaPowerCube,amixtureoflanguagesisdisplayed.
WhenyourestoretheCognos_samples.
zipfileinthewebcontent/samples/contentfolderitcontainsmultilingualcontent.
Whenyouchangethelocalesettingonyourcomputer,reportsappearinthelanguagespecifiedforyourcomputer.
ThisisnottrueforsampleIBMCognosPowerCubes.
WhenyourestoreCognos_PowerCube.
zip,adifferentfolderissetupforeachlanguage.
IfyouselectaPowerCubefromalanguagefolderthatisdifferentthanthelanguagespecifiedbythelocalesettingonyourcomputer,amixtureoflanguagesisdisplayed.
Therearetwooptionsforsolvingthisproblem:vRe-installCognos_PowerCube.
zip.
FirstensurethatyourcomputerissettothelocalethatisconsistentwiththelanguageofthePowerCubepackageyouareinstalling.
Then,installonlythepackagefromthelanguagefolderthatmatchesthelocalesetting.
vOpeneachPowerCubepackage,clicktheSetPropertiesbutton,andintheLanguagebox,selectthelanguageoftheIBMCognosPowerCube.
UnabletoSelectMultipleReportFormatsWhenRunningaReportWhenrunningareportwithoptions,youcannotselectmultipleformatswhenthedeliveryoptionistoviewthereport.
BeforeselectingmultipleformatsontheRunwithadvancedoptionspage,youmustfirstchangetheDeliveryoptiontoSavethereport,printit,orsendane-mail.
AReportorAnalysisDoesNotRunBecauseofMissingItemsYouattempttorunareportoranalysisandamessageindicatesthatoneormoreitemsaremissingorchanged.
EachmissingitemislistedbyitsMUN(memberuniquename).
TheMUNincludesthecompletepathwithinthehierarchyfortheitem.
WhenyouplaceyourcursoronanitemintheSourcetab,theMUNforthatitemisdisplayedinatooltip.
Thissituationmayoccurifmembershavebeenremovedfromorchangedinthedatasource.
ItmayalsooccurwhenyouattemptChapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses81torunareportthatusesitemstowhichyoudonothaveaccess.
Forexample,anadministratormaycreateananalysisthatincludesitemsthatyoudonothavethecorrectpermissiontoaccess.
ThesolutionistofindasuitablereplacementintheSourcetab,anddragittotheworkarea.
Thereportoranalysiswillthenrun.
CannotViewBurstReportWhenyouburstareport,eachburstoutputissenttotheassociatedlistofrecipients.
Ifalistofrecipientscontainsinvalidentries,thefollowingoccurs:vTheburstoutputisnotsavedtoIBMCognosContentManager.
Consequently,youcannotviewtheburstoutput.
vIfyouchoosetosendtheoutputbyemail,onlyvalidrecipientswillreceiveanemail.
AlthoughtheoutputissentasanattachmentifyouselecttheAttachthereportcheckbox,nolinkisgeneratedifyouselecttheIncludealinktothereportcheckbox.
vThefollowingerrormessageappearsintherunhistoryforthereport,whereparameter1istheburstkey,parameter2isthelistofrecipients,andparameter3containstheerrormessagesreturnedbyContentManager:Anerroroccurredwhilesavingtheoutputfortheburstinstancewiththerecipients().
Herearethedetails:Note:Thelistofrecipientsincludesboththevalidandinvalidrecipients.
Forexample,areportissetuptoburstonCountryorRegion,andtherecipientsaremanagers.
Runningthereportproducesthefollowingcountriesandregionsandrecipients:vCanada:John,MaryvUS:Peter,FrankvFrance:Danielle,MaryseFrankisaninvalidrecipient.
TheburstoutputsforCanadaandFrancearesavedtoContentManager,butnottheU.
S.
output.
Ifyouchoosetosendane-mailtoeachrecipientandyouselectedtheIncludealinktothereportcheckbox,thee-mailtoPeterwillnotcontainalinktotheoutputforUS.
TheerrormessagethatisgeneratedwillcontainPeterandFrankasvaluesforparameter2withnoindicationastowhichisinvalid.
Procedure1.
Viewtheerrormessageintherunhistoryforthereport.
2.
Fromthelistofrecipients,determinewhichrecipientsareinvalid.
Youmayneedtoconsultwithyouradministratortofindoutwhichrecipientsareinvalid.
3.
Correctorremovetheinvalidrecipients.
Correctingorremovinginvalidrecipientswilldependonhowthelistofrecipientswasdefined,suchasthroughacalculatedfieldorabursttable.
4.
Runthereportagain.
82IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideRecursiveevaluationerrorYourunareportandencounterthefollowingerror.
PCA-ERR-0057Recursiveevaluationhasexceededlimit.
Calculatedmembertrace:COG_OQP_USR_Aggregate(RetailerType):COG_OQP_INT_m2:COG_OQP_INT_m1:COG_OQP_USR_Aggregate(RetailerType):COG_OQP_INT_m2:COG_OQP_INT_m1:COG_OQP_USR_Aggregate(RetailerType):COG_OQP_INT_m2:COG_OQP_INT_m1:COG_OQP_USR_Aggregate(RetailerType):COG_OQP_INT_m2:COG_OQP_INT_m1Youmayencounterthiserrorwhentwoormoredataitemsformarecursiveevaluation.
Forexample,inthiserror,thecalculationofAggregate(RetailerType)isdependentonacolumnexpressionwhileatthesametimethecolumnexpressionisdependentonAggregate(RetailerType).
Therefore,thecyclicrelationshipcannotberesolved.
Toavoidthisproblem,ensurethatcalculationsdonothavecyclicrelationships.
ArithmeticOverflowErrorWhenRunningaReportinPDFFormatIfyouuseaMicrosoftSQLServer2005datasourceandyourreportincludesaggregations,youmayencounterthefollowingerrorwhenyourunyourreportinPDFformat:RQP-DEF-0177Anerroroccurredwhileperformingoperation'sqlOpenResult'status='-28'.
UDA-SQL-0114Thecursorsuppliedtotheoperation"sqlOpenResult"isinactive.
UDA-SQL-0564[MicrosoftOLEDBProviderforSQLServer]Arithmeticoverflowerrorconvertingexpressiontodatatypeint.
(SQLSTATE=22003,SQLERRORCODE=8115)Thiserroroccursbecausetheactionisperformedinthedatabase,andthedatabasedatatypeistoosmall.
Toavoidthisproblem,increasethesizeofthethedatabasedatatype.
RQP-DEF-0177Anerroroccurredwhileperformingoperation'sqlPrepareWithOptions'status='-69'UDA-SQL-0043ErrorYoucannotrunareportinIBMCognosAnalytics-ReportingorIBMCognosQueryStudio,andthefollowingerrormessagesappear.
RQP-DEF-0177Anerroroccurredwhileperformingoperation'sqlPrepareWithOptions'status='-69'UDA-SQL-0043TheunderlyingdatabasedetectedanerrorduringprocessingtheSQLrequest.
[NCR][ODBCTeradataDriver][TeradataDatabase]PartialstringmatchingrequirescharacteroperandsTheseerrormessagesdonotindicateanIBMCognosApplicationFirewallproblem.
Thereisaproblemwithyourdatasourcenotconvertingnumericdataitems.
AskyouradministratortoconsultthetopicEnableConversionofNumericSearchKeystoStringsinQueriesintheIBMCognosAnalyticsAdministrationandSecurityGuide.
PCA-ERR-0087errorwhenyourunalargereportYourunalargereportandyoureceiveaPCA-ERR-0087errorthatindicatesthatthereportexceedsthemaximumnumberoftuplesallowed.
Chapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses83PCA-ERR-0087The"crossJoinSet"operatorisnotapplicable.
Thelimitonthenumberoftuplesperedgehasbeenexceeded().
Thiserrorappearswhenthereisaniteminaquerythathasnorelationshiptotherestofthedataordoesnotmakesenseinthequery.
Toresolvetheproblem,reviewthequeryforunrelateditems.
Ifanitemisfound,redesignthequeryorapplyafilterontheitemtoreducethenumberofresultsreturned.
Ifyoustillreceivetheerror,askyouradministratortomodifythemaximumnumberoftuplessettinginIBMCognosAnalytics.
ThesettingisanXMLattributenamedmaxTuplesPerEdge.
Formoreinformation,seetheIBMCognosAnalyticsAdministrationandSecurityGuide.
MicrosoftExcelreportdoesnotopenwhenusingtheui.
backURLparameterwithMicrosoftInternetExplorer9.
xWhentheui.
backURLURLparameterpointstoawebaddressotherthanaCognosAnalytics8.
4.
1serverandyouareusingMicrosoftInternetExplorer9.
x,the"Doyouwanttoopenorsavefrom"messageflashesquicklyinMicrosoftInternetExplorer9.
xandthendisappears.
Ifyoudonotusetheui.
backURLparameterthenthe"Doyouwanttoopenorsavefrom"messageappearsandtheMicrosoftExcelreportopenswhenyouclicktheOpenbutton.
YoucanalsoopentheMicrosoftExcelreportiftheui.
backURLparameterusesthesamehostnameastheCognosAnalyticsserverthatcontainstheExcelreportorifyouuseMicrosoftInternetExplorer8.
x.
DifferencesintheappearanceofchartsthatarerunindifferentformatsorondifferentoperatingsystemsIBMCognosAnalytics-Reportingchartscanappeardifferentlywhenreportsarerunindifferentformatsorondifferentoperatingsystems.
Forexample,donutandpiechartscanappearsmallerinreportsthatarerunontheLinuxonSystemzoperatingsystemcomparedtotheWindowsoperatingsystem.
ThedifferencesinappearanceoccuronlywithCognosAnalytics-Reportingdefaultcharts.
CognosAnalytics-Reportinglegacychartsarenotaffected.
WhendefaultchartsarerenderedinHTMLorPDF,thefollowingfont-relatedproblemsmightoccur.
vThefontthatisusedinHTMLoutputisdifferentthanthefontusedinPDFoutput.
vSomechartitemsappearmisaligned.
Forexample,apiechartmightshowsmallerpiesinPDFoutputthaninHTMLoutput.
vThefontthatisusedinthechartisdifferentfromtheexpectedfont.
vThefontthatisusedinthechartisdifferentwhenyourunthechartindifferentoperatingsystems.
Therearetwopossiblecausestothefont-relatedproblems.
vTheJavaRuntimeEnvironment(JRE)usedbyIBMCognosAnalyticsdidnotfindthefontthatisspecifiedinthechart,andsubstitutedthefontwithadifferentfont.
84IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidevAnunknowndefaultfontisspecified.
Toresolvetheproblem,askyouradministratortoconfigureJREtofindtheinstalledfontsontheCognosAnalyticsserver.
TherearetwowaysthatyoucanconfigureJREtofindtheinstalledfonts:vCopytheinstalledfontstothejre/lib/fontsfolder.
Forexample,tousetheCognosAnalyticsdefaultfontAndaleWT,copyAndalewt.
ttffromtheinstall_location/bin/fontsfoldertojre/lib/fonts.
vConfiguretheJREfontsearchpathtopointtothelocationwherethefontsareinstalled.
OnAIX,settheshellenvironmentvariableJAVA_FONTS=Tip:Settingthisvariableisequivalenttosettingthepropertiesjava.
awt.
fontsandsun.
java2d.
fontpath.
ThedefaultfontsconfigurationinyourCognosAnalyticsserverdefaultstylesheetcanalsocausefont-relatedproblems,particularlywhentheoperatingsystemisUNIX.
OnUNIXsystems,fontsmustbepurchasedandinstalled.
Toensurethataspecificfontisused,performoneofthefollowingtasks:vAskyouradministratortoupdatetheCognosAnalyticsserverdefaultstylesheettoreflectthefontsthatareinstalledontheserver.
vUpdatethechartfontsthatareusedinyourreporttousethatfont,anddonotrelyonanydefaultfonts.
Out-of-memoryerrorswithreportsthatarerunininteractiveHTMLformatOut-of-memoryerrorsoccurwhenyourunareportininteractiveHTMLformat.
Theerrorsdonotoccurwhenyourunthereportinotherformats,suchasPDForsavedHTML.
Out-of-memoryerrorsoccurinreportsthatcontainmanyobjectsthatrequirememoryintensiveprocessing,suchascrosstabsandchartsthatarelinkedtogetherwithmaster-detailrelationships.
RunningreportsininteractiveHTMLcanconsumemorememorythanrunningreportsinotherformats.
WhenareportisrunininteractiveHTML,datasetsarekeptinmemoryforallpagesinthereport.
ForreportformatslikePDF,datasetsarereleasedfrommemoryafterthereportisrendered.
Undercertainconditions,youcanexceedthememorylimitationsofa32-bitconfigurationoftheCognosAnalyticsserverreportservercomponentwhenyouinteractwithaninteractiveHTMLreport.
Forexample,scrollingthroughareportpagebypageordrillingupordrillingdowncanconsumemorememoryandprocessingcapacityininteractiveHTMLthaninotheroutputformats.
Drill-throughlinksinactivereportsdonotworkWhenviewinganactivereportthatcontainsdrill-throughlinksinMicrosoftInternetExplorer8andlater,thelinksdonotwork.
Clickingonadrill-throughlinkproducesanerrorlikethefollowing:Thesearchpath""isinvalid.
Anobjectmaycontaininvalidsyntax,oranunsupportedcharacter,ortheuseraccountintheChapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses85namespacemaynothavesufficientprivileges.
Checktheobjecttoensurethatthetargetdestinationlocationdoesnotcontainspecialcharacters.
DetailsCM-REQ-4069Theproperty"na"isunknown.
Replaceitwithavalidproperty.
Whenclickingalinkinanactivereport,youareattemptingtomovefromalocaldomain(theactivereportMHTfileonyourcomputer)totheIBMCognosAnalyticsserver'sdomain.
InternetExplorerviewsthisasapotentialrisk.
Toresolvetheproblem,makethefollowingchangestothesecuritysettingsinInternetExplorer.
Procedure1.
ClickTools,InternetOptions.
2.
ClicktheSecuritytab.
3.
ClickTrustedsitesandthenclickSites.
4.
IntheAddthiswebsitetothezonebox,typetheIBMCognosAnalyticsserver'sdomain.
5.
ClickAddandthenClose.
6.
ClickCustomlevel.
7.
IntheScriptingsection,underEnableXSSfilter,clickDisableandthenclickOKtwice.
PerformanceProblemsWhenRunningReportsThetopicsinthissectiondocumentperformanceproblemsyoumayencounterwhenrunningreports.
CGITimeoutErrorWhileTransferringDatatoIBMCognosAnalyticsComponentsWhenperformingoperationsthroughyourWebbrowser,youreceiveanerrormessage.
ThefollowingerrormessageappearswhenyouuseMicrosoftWindowsInternetInformationServices(IIS)asyourWebserverandthegatewayisconfiguredtouseCGI.
IIShasadefaulttimeoutforCGIapplications.
CGITimeout,processwillbedeletedfromserver.
Toresolvethisproblem,youcanconfigurethegatewaytouseISAPI.
IISdoesnothaveadefaulttimeoutforISAPIapplications.
Or,ifyouwanttokeepusingaCGIgateway,youcanincreasetheCGItimeoutinIIS.
Procedure1.
TochangethegatewaytoISAP,dothefollowing:vOnthegatewaycomputer,startIBMCognosConfiguration.
vUnderEnvironment,fortheGatewayURIproperty,changethecognos.
cgiportionoftheURItocognosisapi.
dll.
vInyourWebbrowser,specifytheISAPIURI:http://computer_name/ibmcognos/isapi2.
ToinclreasetheCGItimeout,dothefollowing:86IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidevIntheMicrosoftWindowsadministrativetools,openInternetInformationServices.
vUnderthelocalcomputernode,right-clickWebsitesandselectProperties.
vIntheHomeDirectorytab,clickConfiguration.
vIntheProcessOptionstab,increasetheCGIscripttimeout.
TheBAP-ERR-0002BAPIErrorWhenusingIBMCognosAnalyticswithanSAPBWdatasource,thefollowingerrormessagemayappear:BAP-ERR-0002BAPIerroroccurredinfunctionmoduleBAPI_MDDATASET_CHECK_SYNTAX.
Erroroccurredwhenstartingtheparser.
ThiserrorusuallyoccursbecausetheSAPBWserverisoverloaded.
Toresolvethisproblem,restarttheIBMCognosAnalyticsserverorcloseallopenconnectionsfromtheSAPBWAdministratorWorkbench.
TheOutofMemoryErrorAppearsinHP-UXInHP-UX,thedefaultsettingforthethreadsperprocessistoolowformostJavaapplications.
Toavoidoutofmemoryerrors,increasethevalueforthefollowingkernelparameters:vmax_thread_procvnkthread.
Note:Thenkthreadparametershouldbedoublethevalueofthemax_thread_procparameter.
Formoreinformation,seetheHPWebsite.
AQueryIsSlowWhenFilteringNon-ASCIITextWhenusinganSAPBWdatasource,andrangefiltersaredefinedonnon-ASCIItextvalues,suchascitynamesthatcontainaccentedcharacters,thequerymaytakelongertorun.
ThisoccursbecausethefiltermustbeperformedontheapplicationserverandnotontheSAPBWserverbecauseSAPBW3.
0BsupportsqueriesonlyiftheyuseASCIIvalues.
Toavoidthisproblem,donotfilternon-ASCIIvalues.
ReportOutputTakesaLongTimetoRunYouclickRunwithOptionsandselecttheSavethereportdeliveryoption.
Thisactionreturnsalldata,rendersthereport,andstoresitinthecontentstore,whichcantakealongtime.
Itisquickertorunthereportmanually,usingtheRuncommand,whichgeneratesthereportapageatatime.
ReportrunsslowlyThefollowingisalistofquestionsthatwillhelpyoutotroubleshootaslowreport.
vDoesyourIBMCognosenvironmentconformwiththesupportedenvironmentsChapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses87vHasthereportalwaysbeenslowordiditrecentlybecomeslowIfitrecentlybecameslow,canyouidentifyaneventthatoccurredjustbeforethereportbegantorunslowlyEventscouldincludechangestoconfigurationsettings,changestotuningsettings,arecentupgradewhereyourprevioussettingshavenotbeenapplied,anintroductionoffirewallsorproxies,changestoexistingfirewallsorproxies,changestovirusscansontempdirectories,ortemporarytablespacerestrictionsonthedatabase.
Thiseventcouldhavecausedthechangeinreportperformance.
vIstheperformanceslowforallreportsorjustonereportIfallreportsareslow,theissuemaybeduetoyourenvironmentordatabase.
Ifallreportsfromaspecificpackageareslow,theissuemayduetothemodeldesign.
Ifjustonereportisslow,theissuemaybeduetoaspecificreportelement.
vHowmanyqueriesdoesyourreportcontainThenumberofqueriesonthereportwillproportionallyaffectthereportexecutiontime.
vDoesthereportrunslowlyforeveryone,orjustforoneuserIfthereportrunsslowlyforjustoneuser,theissuemaybeduetosomethinginthatuser'senvironment,suchasvirusscanning,pagefilesizeorlocationsettings,ortheirlocationonthenetwork.
vIsthereportburstorrunoftenbymanypeopleIfmanypeoplearerunningthesamereportatthesametime,youmayneedtoscaleyourenvironmentorconsiderusingdispatcherroutingrulestodirectallrequestsforaspecificpackageorgroupofuserstoaspecificserverorservergroup.
Formoreinformation,seetheIBMCognosAnalyticsAdministrationandSecurityGuide.
vDoyourqueriesrequirelocalprocessingThefollowingreportelementsrequirelocalprocessing:crosstabsandcharts,masterrelationships,unionsorjoins,multiplefactqueries,bursting,andnon-vendorspecificfunctions.
LocalprocessingrequirestheIBMCognosservertocomputeoperationsontheresultsetreturnedbythedatabase,whichcanimpacttheSQLexecutiontime.
vDoesyourenvironmentuseaCustomAuthenticationProviderUsingaCustomAuthenticationProvidercouldcauseamemoryleakifthecodeisnotdestroyingobjectscorrectly.
vHaveyoureviewedthelogsintheinstall_location/logsdirectoryandtheauditlogsTheymayhelpyouidentifythesourceoftheproblem.
Monitoringyourprocesses,suchastheJavaandthebusprocessescouldalsoidentifyexcessivememoryuse.
vIsyourenvironmenttunedcorrectlyvHaveyourecentlyupgradedEnsurethatanytuningsettingsthatwereappliedtoyourpreviousinstallationareappliedtothenewenvironment.
Ensurethatyourmodelshavebeenverified,upgraded,andrepublished.
VerifythattheIBMCognosFrameworkManagergovernorthatallowsenhancedmodelportabilityatruntimeisnotenabled.
Dependingonyourupgrademethod,youmayalsoneedtoopenandsavethereportsagainafterupgrading.
88IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideProblemsViewingReportsThetopicsinthissectiondocumentproblemsyoumayencounterwhenviewingreports.
AnupgradedreportdoesnotretainitsoriginallookWhenyouupgradeareporttoIBMCognosAnalytics,anewstylesheetisappliedthatchangesthelookofthereport.
Topreservetheformattingthatwasusedintheoriginalreport,youcanselectadifferentstylesheet.
Thisretainstheoriginallookofthereportandspecifiesthatanynewitemsaddedtothereport,suchaslistcolumnsorcrosstablevels,havetheoriginalformattingappliedtothem.
Procedure1.
OpenthereportinIBMCognosAnalytics-Reporting.
2.
ClickthePagesiconortheQueriesicon,andthenclicktheReporticon.
3.
ClicktheShowpropertiesicon,andinthePropertiespane,clicktheReportstylespropertyandselectoneoftheavailablevalues.
Forexample,tousetheIBMCognosReportNetstylesheet,select1.
xstyles.
PreventingfontchangesthatcausetextwrappinginPDFreportoutputsInanupgradedIBMCognosAnalyticsenvironment,ifyouworkwithreportscreatedinolderversions,youmightfindthatsomequerydatainPDFreportsnowwrapsontoasecondline.
YoucansettheadvancedpropertyRSVP.
RENDER.
PDF_FONT_SWITCHINGtorestorethefont-choosingbehaviourofearlierversionsofIBMCognosAnalytics.
AboutthistaskIBMCognosAnalyticssoftwareusespreferredfonts.
Thepreferredfontisanyfontlistedinareportspecification,followedbythefontslistedintheglobalstylescascadingstylesheet(css)file.
Ifthefirstfontcannotbeused,thesoftwareusesthenextfontinthelist.
InpreviousversionsofIBMCognosAnalytics,afontwasusedonlyifallcharactersinastringcouldbedisplayedusingthatfont.
StartingwithIBMCognosAnalytics10.
1,thepreferredfontisappliedatthecharacterlevel.
Whenacharacterisnotavailableinthepreferredfont,itisdisplayedinthenextfontspecified.
Asaresult,onewordcanbedisplayedusingdifferentfonts,orsomefontsmightbebigger,whichcancausewordwrapping.
Ifyouhavethisproblem,configureIBMCognossoftwaretochoosefontsusingtherulesfrompreviousversionsoftheproduct.
YoucandothisbysettingtheRSVP.
RENDER.
PDF_FONT_SWITCHINGadvancedsettingtofalseforthereportandbatchreportservices.
Procedure1.
InIBMCognosAdministration,ontheConfigurationtab,clickDispatchersandServices.
2.
Clickthedispatcher.
Chapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses893.
FortheBatchReportService,intheActioncolumn,clicktheSetpropertiesicon.
4.
ClicktheSettingstab.
5.
ForAdvancedsettings,clickEdit.
6.
ClickOverridethesettingsacquiredfromtheparent.
7.
TypetheparameterRSVP.
RENDER.
PDF_FONT_SWITCHING8.
IntheValuecolumntypeFalse9.
ClickOK.
10.
Repeatsteps3to9fortheReportService.
MeasureFormatDisappearsinSSAS2005MicrosoftSQLServer2005AnalysisServices(SSAS)doesnotpropagateformattingthroughcalculations.
IBMCognoscompensatesforthiswheneverpossible,butcannotguaranteetodosoinallcases.
Asaresult,ifyouareworkingwithaMicrosoftSSAScube,anycalculation(otherthananon-countsummary)thatisbasedonorintersectswithaformattedmeasure,suchasacurrency,maylosethemeasureformat.
Thismayalsohappenifyouuseadetailfilterorcontextfilter(slicer).
Forexample,acrosstabincludesmembersononeedgeandameasurewithformatting,suchasacurrencysymbolanddecimalplaces,appliedontheotheredge.
Whenyourunthereport,youseetheformattingforeachcell.
However,ifyouaddadetailfilter,suchasmeasure>1andrunthereport,alltheformattingdisappears.
Additionally,thefinedetailsoftheMDXgeneratedbyIBMCognosAnalyticscanchangefromreleasetorelease.
AstheSSASbehaviordependsontheMDXgenerated,thelossofformattinginreportsmightnotoccurinafuturerelease.
Toavoidthisproblem,specifyexplicitformattingfortheaffectedrow,column,orcell.
ARunningTotalinGroupedReportsGivesUnexpectedResultsYouhavearunningtotalcalculationinagroupedreportthatreturnsunexpectedvalues.
Becausetabulationoftherunningtotalcalculationdependsontheorderinwhichthegroupingisexecuted,youmustensurethatthegroupedtotalsaretabulatedbeforeapplyingtherunningtotal.
Toensurethatthegroupingisexecutedincorrectorder,definearunningtotalcalculationasafreestandingcalculationoutsidethequerysubjectinIBMCognosFrameworkManager,andensurethattheRegularAggregatepropertyissettoAutomatic.
Thismayalsobeanissuewithotherrunning,moving,andrankingaggregations.
ThePageCannotBeFoundErrorAppearsforReportsWhenareportisdistributedbyemail,noerrormessageappearsifthereportoutputfromtheemaillinkisnotavailable.
Thiscanoccurwhentheoutputis90IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidedeletedorwhentheuserdoesnothavepermissionstothereport.
Instead,theerrorThePageCannotBeFoundappears.
YouareunabletoviewthereportoutputfromtheemaillinkwhenAllowAnonymousAccessissettoTrueandwhentheAnonymoususerdoesnothaveaccesstothereportoutput.
WhenyourunasecuredreportfromanemaillinkandwhenAllowAnonymousAccessissettoTrue,apassportisautomaticallyissuedtotheAnonymoususer.
TheAnonymoususerisnotpromptedtologonandisunabletoviewthereportoutput.
Non-EnglishCharactersAppearasPlaceholdersIBMCognosAnalyticsandFrameworkManagerareUnicodeapplications.
AUnicodeapplicationpermitshandlingofcontentinanylanguage,oranycombinationoflanguages.
However,ifyourdatabasecontainsnon-Englishcharacters,andifthedatabaseclientisnotconfiguredtoreceivethesecharacters,somecharactersmayappearasplaceholdercharacters,suchasboxesorinvertedquestionmarks.
Toavoidthisproblem,ensurethatyourdatabaseclientsareproperlyconfigured.
Formoreinformation,seeyourdatabasevendordocumentation.
ForOracle9,youcanforcetheuseofUnicodeontheclientbyensuringthatthesystemenvironmentvariableNLS_LANGissetto"xxx.
UTF8",wherexxxiswhateverisneededforotherapplicationsonthatcomputer.
Iftherearenone,thevaluecanbesimply.
UTF8.
WhileenforcingtheuseofUnicodeonthedatabaseclientguaranteesthatitcanhandlemultilingualdata,somecharactersinsomecharactersetsmaystillappearincorrectly,suchasJapaneseShift-JIS.
ChartsDoNotAppearinHTMLreportsInIBMCognosAnalytics,HTMLoutputreportsaredisplayedinMicrosoftInternetExplorer6.
xwith24-bittransparencytoensurethattheappropriatecolordepthisdisplayed,typicallyforcharts.
IfyouoperateinanenvironmentthatrequirestheInternetExplorer6.
xsecurityleveltobesettohigh,chartsmaynotappear.
Ifyoucannotlowerthesecuritysettingforsecurityreasons,youmaywanttodisablecharttransparency.
ChartsaredisplayedinInternetExplorerwithtransparenciesdisplayedinwhite.
YoumusthavetherequiredpermissionstoaccessIBMCognosAdministrationfunctionality.
Procedure1.
OntheStatustabinIBMCognosAdministration,clickSystem.
2.
Intheupper-leftcorneroftheScorecardpane,clickthearrowtoviewtheChangeviewmenu.
ClickServices,ReportData3.
ClickthearrownexttotheservicetodisplaytheActionsmenu,andthenclickSetProperties.
4.
ClicktheSettingstab.
5.
FortheEnvironmentcategory,nexttoAdvancedsettings,clicktheEditlink.
Chapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses916.
Ifitappears,selecttheOverridethesettingsacquiredfromtheparententrycheckbox.
Otherwise,proceedtothenextstep.
7.
IntheParametercolumn,typeEnableChartTransparencyIE.
8.
IntheValuecolumn,typeFalsetodisablecharttransparencyinInternetExplorer.
9.
ClickOK.
10.
ClickOKagain.
CrosstabdisappearsinPowerPlayStudiowhenchangingthezoomlevelinIE8WhenchangingthezoomviewinMicrosoftInternetExplorer8,thecrosstabinIBMCognosPowerPlayStudiodisappears.
ThecrosstabinPowerPlayStudiodoesnothaveanabsoluteposition,andthereforemightdisappearfromthescreenwhenchangingthezoomlevel.
Toresolvetheproblem,switchyourbrowserfromfullscreenmodetowindowmodeandchangethesizeofyourbrowserwindowslightly.
Mostofthetime,thecrosstabwillreappear.
Basedonthesizeofyourbrowserwindow,thecrosstabwilldisappearonadifferentpercentageofzoom.
CognosStatisticsobjectisnotdisplayedinareportAnIBMCognosStatisticsobjectisnotdisplayedinareport.
Eachremovedstatisticalobjectisreplacedwithanimageinthereport:AwarningalsoisdisplayedintheUpgradeInformationwindowforeachstatisticalobjectthatisreplacedwiththeimage.
BeginningwithIBMCognosBusinessIntelligenceversion10.
2.
1,IBMCognosStatisticsisnolongeravailable.
Toensurethatreportsthatwerecreatedinpreviousreleasesandthatcontainstatisticalobjectsrun,statisticalobjectsareremovedwhenthereportsareupgraded.
Tip:Queries,andtheirdataitems,thatareassociatedtostatisticalobjectsarenotremovedfromupgradedreports.
YoucanuseIBMSPSSStatisticstoperformstatisticalreportingandanalysis.
PortalProblemsThetopicsinthissectiondocumentproblemsyoumayencounterwithaportalwhenviewingreports.
Figure9.
Imagethatreplacesstatisticalobjectsinupgradedreports92IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideCannotConnecttoaSQLServerDatabaseUsinganODBCDriverTheconnectionworksinIBMCognosFrameworkManager,andmetadatacanbeimported.
Whentestingthedatabaseconnectionintheportal,errorsoccur.
Whenthefollowingerrorsoccur,thesolutionistochangetheNetworkLibraryConfigurationforSQLServertouseTCP/IPinsteadofNamedPipes.
QE-DEF-0285LogonfailureQE-DEF-0325Thecauseofthelogonfailureis:QE-DEF-0068Unabletoconnecttoatleastonedatabaseduringamulti-databaseattachto1database(s)in:testDataSourceConnectionUDA-SQL-0031Unabletoaccessthe"testDataSourceConnection"databaseUDA-SQL-0129Invalidlogininformationwasdetectedbytheunderlyingdatabase[Microsoft][ODBCSQLServerDriver][SQLServer]Loginfailedforuser'(null)'.
ReasonNotassociatedwithatrustedSQLProcedure1.
OpenODBCDataSourceAdministrator.
Tip:InMicrosoftWindows2000youcandothisbyclickingStart,Settings,ControlPanel,AdministrativeTools,DataSources(ODBC).
2.
SelectthedatasourcenamedefinedforSQLServerontheSystemorUserDSNtab.
3.
ClickConfigure.
4.
OntheMicrosoftSQLServerDSNConfigurationpage,clickNext.
5.
ClickClientConfiguration.
6.
EnsurethatTCP/IPisselectedfortheNetworklibraryentry.
UnabletoClickLinksLinkswillnotworkifyourbrowserisnotproperlyconfigured.
Consequently,youcannotperformoperationssuchasrunningareportorstartingReporting.
ForallWebbrowsers,cookiesandJavaScriptmustbeenabled.
Formoreinformation,seeyourbrowserhelp.
ForMicrosoftInternetExplorerWebbrowseronly,thefollowingmustbeenabled:vRunActiveXcontrolsandplug-insvScriptActiveXcontrolsmarkedsafeforscriptingvActivescriptingIBMCognossoftwaredoesnotprovideordownloadActiveXcontrolsaspartofIBMCognosAnalytics.
IBMCognosAnalytics-ReportingusesthenativeInternetExplorerXMLsupport,whichisanintegralcomponentofthebrowser.
BecauseMicrosoftimplementsXMLusingActiveX,youmustenableActiveXsupportforReporting.
Procedure1.
InInternetExplorer,fromtheToolsmenu,clickInternetOptions.
2.
OntheSecuritytab,clickCustomLevel.
3.
IntheSecuritySettingsdialogbox,scrolltotheActivexcontrolsandplug-inssettingsandenableRunActivexcontrolsandplug-insandScriptActivexcontrolsmarkedsafeforscripting.
Chapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses934.
ScrolltotheScriptingsettingsandenableActivescripting.
5.
ClickOK.
MissingImagesinaPDFReportImagesthatappearinreportsrenderedasHTMLaremissinginreportsrenderedasPDF.
TheembeddedGIF,JPG,andBMPimagesdonotappear.
Onlythebordersofthemissingimagesappear.
IfyouuseMicrosoftInternetInformationServices(IIS),gotothepropertiessheetoftheWebsiteandensurethattheEnabletheHTTPKeepAlivesoptionisselected.
Ensurethatthevirtualdirectorywheretheimagesarestoredhasanonymousaccessenabled.
OpenIISandopenthepropertiessheetforthevirtualdirectoryforyourimages.
SelecttheAnonymousAccesscheckbox.
Ifyoudonotwanttoopenupanonymousaccesstoallusers,ensurethattheaccountthatisrunningthedispatcherhasaccesstothevirtualdirectorywheretheimagesarestored.
ProblemsPrintingReportsThetopicsinthissectiondocumentproblemsyoumayencounterwhenprintingreports.
ChartsinPDFOutputShowUnexpectedResultsCharts,whenviewedinPDFoutput,havedifferentlevelsofinteractionsupport,dependingontheversionofAdobeAcrobatReaderandthestyleofchartelement.
AdobeReaderversion5doesnotsupporttooltips.
DrillupanddownandGotolinkshavelimitedsupport,duetotechnicallimitations.
Onlyrectangularareasincharts,suchasbars,columns,horizontallabelsontheaxis,orlegendlabelscanbeenabledfordrillorGotointeraction.
Non-rectangularareas,suchaspieslicesinpiecharts,cannotbeenabledfordrillorGotointeractions.
AdobeReaderversion6and7supportstooltips,drillupanddown,andGotolinksforallcharttypes.
Whenchartelementsoverlaporareseparatedbyonlyafewpixels,theinteractiveregionmaybesmallerthantheareashown.
APrintedHTMLReportisUnsatisfactoryPrintingHTMLmayproduceunsatisfactoryresults.
Forbestresults,usetheViewinPDFFormatcommand,andthenprintthePDF.
Thisalternativegivesyoumorecontroloversuchthingsaspaginationthanthebrowserdoes.
UnderstandingDrill-ThroughResultsThetopicsinthissectiondocumentunexpectedresultsthatyoumayencounterwhenusingdrill-through.
94IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideFiltersAreNotCorrectWhenUsersDrillThroughtoUpgradedTargetsinAnalysisStudioIfthetargetofadrill-throughdefinitionisanIBMCognosAnalysisStudioreportwithadrill-throughfilter(definedbysettingacontextfilterasaGoToparameter),andtheapplicationhasbeenupgradedfromIBMCognosAnalytics,version8.
3,toIBMCognosAnalytics,version10.
1,filtersmaynotbecorrectlypassedfromthesourcetothetarget.
Instead,theAnalysisStudioreportappearsasitdidinitslastsavedstatewithoutanyfilteringoccurringfromthesourcereport,orusersmaybepromptedtoselectacontext.
Thisistrueforauthoreddrill-throughdefinitions(createdinanIBMCognosAnalytics-Reportingreport)andpackagedrill-throughdefinitionsthatuseparameterizeddrillthrough.
ThisproblemoccursbecauseofchangesinhowparametersareautomaticallynamedinAnalysisStudio.
Tocorrecttheproblem,recreatethemappinginthedrill-throughdefinition,andsavethedefinition.
StepsforAuthoredDrillThroughIffiltersarenotcorrectlypassedfromthesourcetothetarget,youcancorrecttheproblembyrecreatingthemappinginthedrill-throughdefinition,andsavethedefinition.
Procedure1.
InReporting,openthesourcereport.
2.
Selectthereportitemthatcontainsthedrill-throughdefinition.
3.
FromthePropertiespane,openthedrill-throughdefinition(Data,Drill-ThroughDefinitions).
4.
FromtheDrill-ThroughDefinitionswindow,opentheParameterstable,andre-selectthetargetparameter(s).
5.
Savethedrill-throughdefinitionsettingsandthensavethereport.
6.
Testthedrillthroughtoconfirmthattheproblemisresolved.
ResultsFormoreinformation,seetheIBMCognosAnalytics-ReportingUserGuide.
StepsforPackageDrillThroughIffiltersarenotcorrectlypassedfromthesourcetothetarget,youcancorrecttheproblembyrecreatingthemappinginthedrill-throughdefinition,andsavethedefinition.
Procedure1.
LaunchDrill-throughDefinitions.
2.
Navigatetotherootofthesourcepackage,locatethedrill-throughdefinitiontobeupdated,andclickSetProperties.
3.
IntheTargettab,underParametermapping,re-selectthetargetparameters.
4.
Savethedrill-throughdefinition.
5.
Testthedrillthroughtoconfirmthattheproblemisresolved.
Chapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses95ResultsFormoreinformation,seetheIBMCognosAnalyticsAdministrationandSecurityGuide.
Drill-throughLinksareNotActiveintheSafariBrowserWhenviewingaPDFreportintheMacintoshSafaribrowser,youcannotopenhyperlinks.
ThisisbecausetheMacintoshSafaribrowserdoesnothavethenecessaryAdobeAcrobatplug-in.
Toavoidthisproblem,usetheHTMLformatwhencreatingdrill-throughreportsthatmaybeviewedinSafari.
UnexpectedorEmptyResultsWhenDrillingThroughWhenyoudrillfromasourcereporttoatargetreport,theremightbenodatareturned.
Thismightbethecorrectresultifthereisnodatathatcorrespondstothedrill-throughselectionsorifyoudonothavepermissiontoviewthedata.
Inothercases,ifnodataorthewrongdataappears,thesourceitemmightnotbemappedtothetargetcorrectlyorthevaluesinthedatasourcesmightnotbeconformed(thevaluesdonotmatchinbothdatasources).
Ifyouhavethenecessarypermissions,youcandebugdrill-throughdefinitionsbyusingthedrill-throughassistantfromtheGoTopage(right-clicktheselectioninthesourcereportandselectGoTo).
Youcanviewthepassedsourcevaluesandthemappingtothetargetreportparameters.
Youcanusethistoolforbothauthoredandpackagedrill-throughdefinitions.
Youmightbeabletocorrecttheproblembymodifyingtheparametermappinginthedrill-throughdefinition.
Forexample,whenyoudrillfromacubetoarelationaldatasource,sometimesnodataisreturnedorthewrongdataisreturnedbecausethebusinesskeyvaluesinthetwodatasourcesdonotmatch.
Youcanchangethedrill-throughdefinitiontopassthecaptionoftheIBMCognosPowerCubememberinsteadofthebusinesskey,butyoumustalsochangethetargetreporttofilteronthecorrespondingstringvalueandnotthebusinesskeyvalue.
However,itisbesttoensurethedatasourcesareconformed.
Inthisexample,thebusinesskeysinthecubeshouldmatchthebusinesskeysintherelationalsource.
Filteringonakeyismoreefficientthanfilteringonalargerstringthatmayormaynotbeindexedinthedatabase.
Formoreinformationondatasourceconformance,searchfor"conformeddimensions"and"businesskeys"intheIBMCognosTransformerUserGuideandtheIBMCognosAnalytics-ReportingUserGuide.
Procedure1.
EnsurethatthetargetreportfiltersonastringvaluethatmatchesthecaptionbeingpassedfromthePowerCube.
2.
Editthedrill-throughdefinitionasfollows:vIfthedrill-throughdefinitionwascreatedinIBMCognosAnalytics-Reporting,openthereport,andgotothedrill-throughdefinitionassociatedwiththedrill-throughsourceobject.
Ontheparametermappingpage,selectMembercaptioninthePropertytopasscolumn.
96IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidevIfthedrill-throughdefinitionwascreatedinthesourcepackage,intheIBMCognosAnalyticsportal,clicktheNewicon,Other,Drill-ThroughDefinitions.
Openthepackagedrill-throughdefinition.
OntheTargettabofthedrill-throughdefinition,selectMembercaptioninthePropertytopasscolumnfortheappropriateparameter.
ResultsWhenyoudrillthrough,insteadofthebusinesskey,thecaptionispassedtothetarget.
CannotDrillThroughFromaRelationalSourcetoaCubeBydefault,youcannotdrillthroughfromarelationaldatasourcetoacube.
ThisisbecauseacubeexpectsaMemberUniqueName(MUN)asaparametervalueandrelationalsourcesdonotuseMUNs.
Membershavepropertieswhichincludeabusinesskeyandacaption.
Ifeitherofthesematchdataitemswithintherelationalsource,drillingthroughcanbeperformedaslongasthecubetargetreportisauthoredinReporting.
Ifthesourcedatasourcehasaqueryitem,forexampledisplayname,thatcorrespondstoamemberpropertyinthetargetcube,forexamplecaption,youmustcreatetheparameteronthecaptioninthetargetreport.
Topassthedataitemtothecubetarget,dothefollowing:vInthecubetargetreport,createaparameterthatacceptsthecaptionofthemember.
ThisparametershouldbecreatedinaQuerycalculationobjectfromtheToolboxiconwiththefollowingsyntax.
Typethefollowingfilter([HierarchyorLevel],caption([HierarchyofLevel])=Parameter)Forexample:filter([sales_and_marketing].
[Products].
[Products].
[Productline],caption([sales_and_marketing].
[Products].
[Products].
[Productline])=ProductLine)CannotDrillThroughBetweenPowerCubesBecauseMUNsDoNotMatchWerecommendthatbusinesskeysbeuniquethroughoutthedimensionforPowerCubes.
Thesekeysareusedasthesourcevalueforlevelsinahierarchyofadimension.
Ifthevaluesarenotuniquethroughoutthedimension,thecorrespondingCategoryCodevaluesmaybegeneratedwithtildes.
Forexample,ifacategoryfortheProductLinelevelhasasourcevalueof101andacategoryintheProductTypelevelhasasourcevalueof101,theCategoryCodevaluefortheProductTypelevelisautomaticallygeneratedwithauniquevaluesuchas101~245.
TheCategoryCodevaluesareusedintheMemberUniqueName(MUN)foreachmember,forexample,[SalesandMarketing].
[Products].
[Products].
[Producttype]->:[PC].
[@MEMBER].
[101~245].
Becausethesevaluesaregeneratedautomatically,theycannotbeguaranteedfromonecubebuildtothenextorinabuildforanothercubewiththesamedimensionstructureusingthesamesourcevalues.
Therefore,drillingfromonePowerCubetoanotheronwhatappearstobethesamemembermightnotworksincetheMUNsmightnotmatch.
Chapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses97IftheMUNsdonotmatch,consultthecubemodellerstoseeifthebusinesskeyscanbemadeuniquethroughoutthedimension.
Ifthisisnotlikely,ormighttakesometimetoresolve,youcanusecalculationstopassthesourcevaluefromonePowerCubetoanotherfordrill-through.
Procedure1.
Inthetargetreport,createafilterwiththefollowingsyntax:filter([HierarchyorLevel],roleValue('_businessKey',[HierarchyorLevel])=Parameter)Forexample:filter([SalesCube].
[Products].
[Products].
[Producttype],roleValue('_businessKey',[SalesCube].
[Products].
[Products].
[Producttype])=ProdType)2.
Inthesourcereport,createaQueryCalculationwhichisusedtopassthebusinesskey(sourcevalue)tothetargetreportbymappingittothetargetparameterinthedrill-throughdefinition.
Usethefollowingsyntax:roleValue('_businessKey',[HierarchyorLevel])Forexample:roleValue('_businessKey',[sales_and_marketing].
[Products].
[Products].
[Producttype])DrillingThroughtoIBMCognosAnalyticsfromanIBMCognosSeries7ProductResultsinaFirewallErrorYouuseanIBMCognosSeries7productthatisconfiguredtouseaproxyserver.
WhenyoudrillthroughtoIBMCognosAnalytics,thefollowingerrormessageappears:DPR-ERR-2079FirewallSecurityRejection.
Yourrequestwasrejectedbythesecurityfirewall.
Pleasetryagainorcontactyouradministrator.
ThisisbecausetheIBMCognosAnalyticsWebserverdoesnotrecognizetheproxyservernameandrejectstheentry.
Tocorrectthisproblem,addtheproxyservernameinIBMCognosConfiguration.
Procedure1.
StartIBMCognosConfiguration.
2.
IntheExplorerwindow,clickSecurity,andthenclickIBMCognosApplicationFirewall.
3.
IntheValiddomainsorhostsbox,addtheproxyservername.
4.
FromtheFilemenu,clickSave.
5.
FromtheActionmenu,clickStart.
DetailCellsareNotDisplayedforExcludedItemsWhenDrillingThroughtoPowerPlayStudioInIBMCognosPowerPlayStudio,youcanusetheHide/Showfeaturetohideitemsinareport.
IfyoudrillthroughtoaPowerPlayStudiotargetreporttoanitemthatishiddeninthesourcereport,thetargethasnodetailcellsforthehiddenitem.
98IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideForexample,theyear2005ishiddenontherowedgeinaPowerPlayStudiotargetreport.
Youdrill-throughtothetargetreporton2005inaPowerPlayStudio,AnalysisStudio,orReportingsourcereport.
Thetargetreportshowsnodetailcellsfor2005theyarehidden.
However,iftheShowSummariesoptionisselectedforthehiddencategoriesinthetargetreport,thenthesummaryrowwilldisplaythetotalvaluesfor2005.
Tocorrectthisproblem,donotexcludeitemsinthesourcereportifyouwanttoseethedetailscellsinthetargetreport.
Formoreinformationandexamples,seeUnderstandingDrill-ThroughBehaviorinIBMCognos8atdeveloperWorks(www.
ibm.
com/developerworks).
Drill-ThroughParameterisIgnoredinPowerPlayStudioDuetoaCustomSetWhenatargetPowerPlayStudioreportcontainsacustomsubset,youmaynotseetheresultsyouexpectwhenyoudrillthroughfromasourcereportinAnalysisStudio,PowerPlayStudio,orReporting.
Forexample,thetargetPowerPlayStudioreportcontainsacustomsubsetfortheyear2006.
IfyoudrillthroughfromthesourcereportinAnalysisStudio,PowerPlayStudio,orReporting,theyear2006isdisplayed.
But,sincethecustomsubsetdoesnotincludetheyear2004,thedrill-throughparameterfor2004isignoredanditemsfor2004arenotdisplayed.
Toavoidthisproblem,ensurethatthetargetreporthascustomsubsetsthatincludetheitemsyouwanttodisplayduringdrill-throughfromsourcereports.
Formoreinformationandexamples,searchforUnderstandingDrill-ThroughBehaviorinIBMCognos8atdeveloperWorks(www.
ibm.
com/developerworks).
Drill-ThroughDefinitionisNotAvailableWhenadrill-throughdefinitioniscreatedthereisanoptiontospecifythescopeforthedrill-throughdefinition.
Thespecifieditemcanbeaquerysubject,queryitem,measure,dimension,orlevel.
Theitemmustbepresentandselectedinthesourcereportwhendrillingthroughtoatargetreportforthedrill-throughdefinitiontowork.
Itmustalsobeavailableinthelistofdrill-throughtargetlinksontheGoTopage.
IfthescopeitemisnotincludedinthesourcereportwhenitiscreatedinAnalysisStudio,Reporting,orPowerPlayStudio,thedrill-throughtargetlinkdoesnotappearontheGoTopage.
Tofixtheproblem,addthescopeitemtothesourcereport.
Formoreinformationandexamples,seeUnderstandingDrill-ThroughBehaviorinIBMCognos8atdeveloperWorks(http://www.
ibm.
com/developerworks).
CalculationsDoNotAppearintheTargetReportIfyoudrillthroughtoPowerPlayStudiofromareportinReporting,AnalysisStudio,orPowerPlayStudio,calculationsontheedgesinthetargetreportmightnotappear.
Forexample,youhaveatargetreportwiththecalculationPersonalAccessories+100asacolumninacrosstabreport.
Whenyoudrillthroughfromasourcereporttothetargetreport,ifPersonalAccessoriesisfilteredoutofthetargetreport(PersonalAccessoriesisnotoneoftheitemsthatisreturnedonthecolumnedge),thenthePersonalAccessories+100calculationdoesnotappear.
PersonalAccessorieshasbeenfilteredoutofthetargetreportandisnotavailabletofulfillthecalculation.
Chapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses99Toseethecalculationsinthetargetreport,ensuretheitemsusedinthecalculationsarereturnedintheresultset(notfilteredout).
Formoreinformationandexamples,seeUnderstandingDrill-ThroughBehaviorinIBMCognos8atdeveloperWorks(www.
ibm.
com/developerworks).
TargetReportDoesNotFilterProperlyWithout"Go-To"ParametersInAnalysisStudio,youcanmulti-selecttwoormoreitemsfromadimensionandaddthemtotheContextFilterareatocreatealistofitems(asetofmembersfromonedimension)thattheanalysisisfilteredon.
Forexample,Telephone,Web,SalesVisitandSpecialaremulti-selectedfromOrdermethodtypeanddroppedontotheContextFilterareaofanAnalysisStudiotargetreport.
Ifadrill-throughdefinitioniscreatedforthistargetreport,whenyoudrillthroughfromasourceReporting,PowerPlayStudio,orAnalysisStudioreport,allcontextfilteritemsarereturnedeventhoughtheyarenotpartoftheintersectionselectedfordrill-through.
ThisisbecauseAnalysisStudiodoesnotdynamicallyfilterfromsourcereports.
EnableGoToparametersonthecontextfilterinordertodrillthroughandfilterthereportsasexpected.
InthedropdownmenufortheContextFilter,selectUseas"GoTo"Parameter.
ForanyitemsthatyouwishtofilteroninanAnalysisStudiotargetreportdrill-through,acontextfiltermustbecreatedandsetasaGoToparameter.
Formoreinformationandexamples,seeUnderstandingDrill-ThroughBehaviorinIBMCognos8atdeveloperWorks(www.
ibm.
com/developerworks).
EmptyCellsReturnedinaTargetReportwithExcludedItemsInIBMCognosAnalytics,tofilteranAnalysisStudiotargetreportonadrillthrough,contextfiltersmustbecreatedandsetasGoToparameters.
Eachcontextfiltermustcontainalltheitemsfromthedimensionthatyouwishtofilteron,forexample,acontextfiltermightcontaintheyears2004,2005,2006,2007.
Forexample,anAnalysisStudiotargetreporthascontextfilterforyears,butexcludestheyear2005ontherowedge.
Ifyoudrillthroughtothistargetreporton2005fromaPowerPlayStudio,Reporting,orAnalysisStudioreport,thereportdisplaysemptycells.
Thisisanaccurateresultsincethetargetreporthasfilteredouttheyearsdisplayedinthereportlayout(forexample,2004,2006,2007).
Thereporthasbeenfilteredontheexcludeditem,2005.
However,thesummarytotalrowshowsvaluesfor2005sinceitprovidestheoveralltotalforincludedandexcludeditemsofthereport.
Formoreinformationandexamples,seeUnderstandingDrill-ThroughBehaviorinIBMCognos8atdeveloperWorks(www.
ibm.
com/developerworks).
NestedCrosstabOnlyFiltersonSomeItemsIfyouperformaparameter-baseddrill-throughfromasourcereporttoanIBMCognosAnalytics-Reportingtargetreportwithtwoormoredimensionsnestedonaroworcolumn,youmayencounterunexpectedresultsdependingonthefiltersappliedtothetargetreport.
Forexample,atargetCognosAnalytics-Reportingreporthasthefollowingtwofilters:100IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidev[sales_and_marketing_mdc].
[Ordermethod].
[Ordermethod].
[Ordermethodtype]=OrderMethodTypev[sales_and_marketing_mdc].
[Retailers].
[Retailers].
[Region]=RegionOrdermethodtypeandRegionbothhavefilters,butProductlinedoesnot.
Adrill-throughdefinitionmappedtotheappropriateparameters,inthiscaseOrdermethodtypeandRegion,iscreated.
WhenthesourcereportisrunandtheintersectionofOutdoorprotection,NorthernEurope,andTelephoneisselectedtodrillthroughtothetargetreport,theordermethodtypeandregiondisplayasexpected,butallproductlinesarereturned.
ThisisbecausetherearefiltersonOrdermethodtypeandRegionbutnotProductline.
Formoreinformationandexamples,seeUnderstandingDrill-ThroughBehaviorinIBMCognos8atdeveloperWorks(www.
ibm.
com/developerworks).
DataDoesNotAppearinaTargetReportortheWrongDataAppearsIfnodataappearswhenyoudrillthroughtoatargetreportorifthewrongdataappears,theproblemmightbedatasourceconformance.
Thebusinesskeysmightbedifferentormightbemismatched.
Forexample,thebusinesskeyforCampingEquipmentmightbe100inthedatasourceforthesourcereportand1inthedatasourceforthetargetreport,inwhichcasenodataappearsinthetargetreport.
AnotherexamplemightbethatthebusinesskeyforCampingEquipmentis100inthedatasourceforthesourcereportbut,inthedatasourceforthetargetreport,100isthebusinesskeyforGolfEquipment,inwhichcasethewrongdataappearsinthetargetreport.
Tosolvetheproblem,ensurethatbusinesskeyshavethesamevalueinbothdatasources.
Iftherearecaseswheredatadoesnotappeartomatch,contactyourdatabaseadministratorordatamodeler.
Formoreinformationaboutdatasourceconformance,searchfor"conformeddimensions"and"businesskeys"intheIBMCognosTransformerUserGuideandtheReportingUserGuide.
Youmightalsowanttosee"UnexpectedorEmptyResultsWhenDrillingThrough"onpage96.
DataisNotFilteredintheTargetReportAfterDrill-ThroughYoudrillthroughtoatargetreport,butnofilteringoccursinthetargetreport.
Forexample,youdrillthroughonacrosstabintersectionofCampingEquipmentand2010andexpecttoseeonlydataforCampingEquipmentfor2010inthetargetreport.
Insteadyouseeallproductsforallyears.
Thisoccursbecausethetargetreporthasnofiltersfortheparametersthatwerepassed.
Tosolvetheproblem,ensurethatthetargetreporthasthecorrectfilters.
Inthepreviousexample,thecorrectfiltersinthetargetreportareProductlineandYear.
Alternatively,youcanenableDynamicDrill-Throughinapackage-baseddrill-throughdefinition.
Chapter6.
ProblemsRunning,Viewing,orPrintingReportsandAnalyses101102IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideChapter7.
IBMCognosWorkspaceAdministrationProblemsUsethistroubleshootinginformationtohelpsolveproblemsyoumayencounterduringoraftertheinstallationofIBMCognosWorkspace.
SecureConnectionFailederrorwhenaccessingIBMConnectionsYouhaveenabledcollaborationusingIBMConnections,andyoureceiveanerrorinyourMozillaFirefoxWebbrowserwhenyouaccessIBMConnections.
Thefollowingerrorcanoccurifyouareusingsecuresocketlayer(SSL)protocolwhentheSSLalgorithmsdonotmatchbetweenthebrowserandyourapplication.
SecureConnectionFailedAnerroroccurredduringaconnectiontoserver_name.
Cannotcommunicatesecurelywithpeer:nocommonencryptionalgorithm(s).
Toresolvetheerror,updateyourssl3settingsinyourWebbrowser.
Procedure1.
OpenyourMozillaFirefoxWebbrowser.
2.
IntheURLbox,typeabout:config,andpressEnter.
3.
IntheFilterbox,typessl3.
4.
ChangeanyattributesmarkedFalseintheValuefieldtoTrue.
5.
RestartyourWebbrowser,andtrytoaccessIBMConnectionsagain.
ProblemssavingaworkspaceinIBMCognosWorkspaceYoutriedtosavealargeworkspaceandyoureceivedanerror.
ThefollowingerrormightoccurifMicrosoftInternetInformationServices(IIS)isblockingtherequest.
Unabletosavetheworkspace.
Or,youmightseeacontinuouslyspinninghourglass.
Toresolvetheerror,increasethemaxAllowedContentLengthonIIStopreventIISfromblockingyourrequesttosavealargeworkspace.
Procedure1.
OpenyourIISManagerthatishostingtheIBMCognosGateway.
2.
SelectyourSite.
3.
OpentheRequestFilteringfeature.
4.
SelectEditFeatureSettings.
5.
IncreasetheMaximumallowedcontentlengthtoalargervalue.
Youcanperformanetworktracetolearntheminimumcontentlengthrequired.
6.
Saveyourchanges.
7.
RestartIISandtrytosaveyourworkspaceagain.
103104IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideChapter8.
ProblemswhenusingIBMCognosAnalyticsonmobiledevicesUsethistroubleshootinginformationtosolveproblemsthatyoumightencounterwhenconfiguring,running,andviewingIBMCognosAnalyticscontentonmobiledevices.
Problemsmightoccuronthemobileserveroronthemobileclient.
MobileserviceproblemsYoumayencounterproblemswhenconfiguringandrunningIBMCognoscontentonmobiledevices.
ChartsandimagesnotappearingChartsandotherimagesdonotappearinreportsonamobiledeviceifIBMCognosAnalyticsandIBMCognosMobilehavebeeninstalledonaUNIXoperatingsystemthatdoesnothaveXserversoftwareinstalled.
Toresolvethisproblem,configureIBMCognosAnalyticstorunwithXserversoftware.
Procedure1.
Findthebootstrap_*.
xmlfilelocatedintheinstall_location\bindirectoryorintheinstall_location\bin64directory.
Theexactbootstrap_*.
xmlfilenamedependsontheversionofUNIXthatyouareusing.
2.
Addtheline-Djava.
awt.
headless=truetothefollowingstartupparameterinthebootstrap_*.
xmlfile:${java_home}/bin/java-d64-Djava.
awt.
headless=true-Djava.
net.
preferIPv6Addresses=true-Xmx${dispatcherMaxMemory}m-XX:MaxNewSize=${dispatcherMaxMemoryBy2}m3.
Savethemodifiedfile,andthenrestarttheIBMCognosAnalyticsserverfromtheIBMCognosConfigurationtool.
Formoreinformation,seetheIBMCognosAnalyticsInstallationandConfigurationGuide.
ListpromptitemsconsistingofonlyasinglespacearenotsupportedWhilerunningareport,auserchoosesanitemfromalistpromptthatconsistsofonlyasinglespaceandthereportgeneratesanerrorandfailstorun.
Toresolvethisproblem,eitherdonotincludesinglespaceitemsinlistpromptsor,ifyoudoincludethesinglespacethenensurethattheuserdoesnotselectitwhenrunningthereport.
105IBMCognosMobileserviceconfigurationsettingsareresettothedefaultsafterupgradingTheIBMCognosMobileconfigurationsettingsandadvancedsettingsmayberesettotheirdefaultsafterIBMCognosAnalyticsisupgraded.
Toresolvethisproblem,reapplythesettings.
AdvancedHTMLfunctionalityisnotsupportedSomeadvancedHTMLfunctionality,suchasJavascriptandHTMLtables,cannotbeviewedinmobileapps.
Toobtaintablefunctionality,youcanuseIBMCognosAnalytics-Reportingtocreateatable.
java.
lang.
NoClassDefFoundErrorThiserrorcanoccurwhileareportisrunningonaUNIXoperatingsystemiftheserverisrunninginheadlessmode.
Toresolvethisproblem,intheinstall_location/bindirectory,intheIBMCognosAnalyticsstartup.
shfile,addthefollowingparameter:JAVA_OPTS=-Djava.
awt.
headless=truejava.
lang.
InternalError:Can'tconnecttoX11Windowsserverusing':0.
0'asthevalueoftheDISPLAYvariableTheservercannotrunareportbecausetheDISPLAYenvironmentvariablewasnotsetorwassetincorrectly.
Torenderareporttoa.
pngfile,theCognosMobileserverinvokesgraphicsroutines.
Aspartofthisprocess,theservermustalsoinvoketheJavaAbstractWindowsToolkit(AWT)libraries.
ThiserroroccurswhentheDISPLAYenvironmentvariablewasnotsetorwassetincorrectlyandtheservercannotfindtheAWTlibraries.
Toresolvethisproblem,ensurethattheDISPLAYenvironmentvariableissettoX11.
IBMCognosMobileservicestartsbutthenstopsIBMCognosMobileservicefailsduringsystemstartup.
Thismeansthattheservicehasencounteredafatalerror,suchasbeingunabletocreatedatabasetables.
Checkthelogsforadditionalinformation,taketheappropriateactiontocorrecttheproblem,andrestarttheservice.
CognosMobiledatabasetablesarenotcreatedAfterIBMCognosMobilewasinstalledwithIBMCognosAnalytics,thescriptstocreatetheMOB_*tableswerenotrun.
Undernormalcircumstances,theCognosMobiletablesarecreatedautomaticallyaftertheMobileservicestartsforthefirsttime.
106IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideThisproblemmightoccurwhenCognosMobileapplicationtiercomponentsandCognosAnalyticsContentManagerareinstalledindifferentlocations,andtheCognosMobiledatabaseisnotconfiguredproperly.
EnsurethattheCognosMobiledatabaseisconfiguredasdocumentedintheIBMCognosAnalyticsInstallationandConfigurationGuide.
MobileclientproblemsUsersmightencounterproblemswhenaccessingIBMCognoscontentonmobiledevices.
ImagesdonotappearonmobiledevicesReportimagesdonotappearonthemobiledevices.
ThishappenswhenusersusetheirownSSLcertificates,whicharenottrustedbytheJavavirtualmachine(JVM).
Toresolvethisproblem,usersneedtousetheOracleSunkeytoolutilitytoimporttheirSSLcertificateintotheirJVM.
Formoreinformation,seetheSunsoftwaredocumentation.
IBMCognosMobiledoesnotfilterdownstreampromptsforcascadingpromptsusingrepromptUsersdonotseetheexpectedresultsinreportsthathavebeensetupwithcascadingpromptsthatrequirereprompting,thatiswheretheusermustclickRepromptinCognosViewer.
IBMCognosMobiledoesnotapplythefilterscorrectlydownstreamforthecascadingprompts.
Toresolvethisproblem,changethereport'spromptoptionstoAuto-Submit.
Withthisoption,IBMCognosAnalyticswillapplythefilterstothedownstreampromptsasexpected.
RepeatertablesrenderincorrectlyAreportthatincludesarepeatertablethatiswithinablockortableelementdoesnotrendercorrectlyonamobiledevice.
Toresolvethisproblem,rewritethereportsothatrepeatertablesarenotwithinblocksortableelements.
CalendarpromptsshowonlytheGregoriancalendarWhenareportwithanon-GregoriancalendardatepromptisdisplayedinIBMCognosmobileapp,thepromptappearsintheGregoriancalendarformat.
Thereportrunsaftertheuserentersvaluesintheprompt,buttheresultsmaybeemptyorinaccurate.
IBMCognosMobilefailstoconnecttoMicrosoftSQLServerIBMCognosMobileaccessesMicrosoftSQLServerthroughtheJavaDatabaseConnectivity(JDBC)driver,whichusesaTCPsockettoconnecttothedatabase.
IfMicrosoftSQLServerisnotconfiguredtoallowTCPconnections,thenIBMCognosMobilewillnotconnecttothedatabaseandwillreporterrorsinthelogs.
Chapter8.
ProblemswhenusingIBMCognosAnalyticsonmobiledevices107Toresolvethisproblem,enableTCPconnectivityinMicrosoftSQLServer.
LongtextmessagesmaybetruncatedLongtextmessagesmayappeartruncatedonsomepartsofthedeviceuserinterfaceforsomelanguages.
Forexample,theusermayobservethatreportlongnamesandsometranslatedtextmessagesaretruncated.
NoreportsavailablewhenloggedonfromthemobileclientThemobileuserisloggedontotheIBMCognosmobileclient,butcannotaccessanyreports.
Reportsneedtoberunbeforetheyappearinthemobiledeviceinbox.
Procedure1.
Onthemobiledevice,clickBrowse.
2.
Clickareport.
3.
ClickRunReport.
Thereportrunsontheserver.
4.
ClickRefreshinboxtorefreshtheinbox.
Thereportappearsinthelist.
SomemobileusersdonotreceiveburstreportsAllmobileusersspecifiedasrecipientsofaburstreportshouldreceivethereportontheirmobiledevicesasscheduled.
Ifsomeusersdonotreceivethereport,thereportmightnotbeproperlyscheduled.
Intheschedulesettingsforthereport,ensurethatthefollowingcheckboxesareselected:vBurstthereportunderBursting.
vSendthereporttomobilerecipientsunderDelivery.
Donotselectrecipientsforthisoptionbecauseburstreportsaredeliveredtousersdefinedintheburstspecification.
Anyrecipientsselectedhereareignored.
Nexttimewhenthereportisrun,allmobileusersshouldreceiveit.
Onlythosereportsforwhichthereportauthordefinedburstoptionscanbedistributedbybursting.
Formoreinformationaboutburstreports,seetheIBMCognosAnalytics-ReportingUserGuideandtheIBMCognosAnalyticsAdministrationandSecurityGuide.
108IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideIndexSpecialcharacters--characterstroubleshootinginreports64.
dmp,SeecoredumpfilesNumerics64-bitapplicationserverproblemconnectingtoIBMCognosAnalyticsportal33Aaccentedcharactersnotdisplayedproperly28accessdeniederror53accesspermissionstoentriesdenied45ActiveDirectoryServermissinggroupmembership39singlesignonnotworking49activereportsdrill-throughlinksdonotwork86advancedsettingsresettingwhileupgradingIBMCognosAnalytics106aggregatingtroubleshootingrunningtotals90AIXerrorconnectingtoDb2database19AnalysisStudiotroubleshooting95applicationserversproblemsrunningIBMCognosAnalytics33startupscriptfails27arithmeticoverflowerrors83ASCIIrequirementsforinstallationdirectory23authenticationActiveDirectorysinglesignonnotworking49expiredpassword48authenticationprovidersproblems48Bbackgroundscolorsnotappearingintemplates63troubleshootingincharts61BAP-ERR-0002errors87binaryround-offerrors71browsersettings93burstreportstroubleshooting82CC8DB2.
shscripterror36calculationsunexplainednumberdiscrepancies71calculationsdonotappearintargetreporttroubleshootingdrillingthrough99calendarpromptsincorrectresults107CAM-CRP-107146CAM-CRP-1157error14CAM.
AAAerrors81cannotcalltheSDKfromEventStudio74cascadingpromptsproblemswithfilters107cast_Datefunctionstroubleshooting79CCL-BIT-OOO6errormessage37CGItimeouterrors41,86charactersencodingnotsupported15charactersimproperlydisplayed28chartsdisablingtransparency91displayingeverysecondlabel61limitations94notappearing91troubleshootingaxislabels61troubleshootingdifferencesinappearancewhenrunindifferentformatsorondifferentoperatingsystems84troubleshootinggraygradientbackgrounds61chartsonUNIX105ChinesecorruptcharactersduringinstallationonLinux26clientdoesnotconnecttothedatabase108CM-SYS-5007error20CNC-ASV-0001error73CNC-ASV-0007error58CNC-SDS-041359CognosDiagnosticUtilities2Cognosnamespacerecreating34CognosStatisticsobjectmissingfromareport92cogroot.
linkfile33cogstartup.
lockfile4cogstartup.
xmlfileinvalidfile35collationsequencescase-sensitive15colorsnotappearingintemplates63commonsymmetrickeyerrorinprocessingarequest46configurationconfigurationgroup21cryptographicinformationcannotbeencrypted31datalocked34errorwhenencryptinginformation31issues28lockfile4metricdumping7109configuration(continued)settingsnotapplied35unabletoopenIBMCognosConfiguration4unabletosave34configurationgroup21ContentManagerattempttoregisterthedispatcher20errormessages37failstostart20contentstorecompatibleversionsofDb2andJava14deletingtablesfromthedatabase29invalidsettings15upgrading19coredumpfiles6credentialsinvalid45crosstabdisappearsinPowerPlayStudio92crosstabsoverflowerrors79cryptographicerror35cogstartup.
xmlfileinvalid35JREerror35problemsafterupgrading32cryptographicinformationcannotbeencrypted31cryptographickeysregenerating32cubescannotopen23troubleshootingdrillingthroughtorelationaldata96currenciesformattingdisappearinginSSAS200590DdatalockedbyIBMCognosConfiguration34datadoesnotappearintargetreporttroubleshootingdrillingthrough101dataisnotfilteredintargetreporttroubleshootingdrillingthrough101databaseclientfailstoconnect108tablesnotcreated106databasecleanupscripts29databaseconnectioncannotselectODBCastype54connectingtoSQLServer53creating54databasesbulkloadutilitymissing41deletingtables29DB2supportedJavaversions14DB2contentstoreerrorwhenrunningC8DB2.
shscript36DB2-ERR-000540deleterequestfails55,56deployingfailureonOracleorWebSphereApplicationServer28deploymentbrokenlinks57detailcellsnotdisplayedtroubleshootingdrillingthroughtoPowerPlayStudio99dimensionally-modeledrelationaldatasourcestroubleshootingperformanceissues80dimensionsoverlappingnamedsetlevels63disablingcharttransparency91dividingbyzerotroubleshooting62double-bytecharactersimproperlydisplayed28downloadofresourcefails19DPR-CMI-4006error20DPR-DPR-1035error14DPR-ERR-2079errors98DPR-ERR-2082error78drilldowntroubleshooting78drilluptroubleshooting78drill-throughdefinitionnotavailable99drillingthroughcalculationsdonotappearintargetreport99cubestorelationaldata96datadoesnotappearintargetreport101dataisnotfilteredintargetreport101detailcellsnotdisplayedforexcludeditemsinPowerPlayStudio99drill-throughdefinitionnotavailable99emptycellsreturnedintargetreport100linksnotactiveinSafariWebbrowsers96nestedcrosstabonlyfiltersonsomeitems100parameterignoredinPowerPlayStudio99problemswithactivereports86relationaldatatocubes97targetdoesnotfilterproperly100troubleshooting95troubleshootingPowerCubes98wrongdataappearsintargetreport101dumpfiles6DuseCMLargeResultSetparameter20Eemptycellsintargetreporttroubleshootingdrillingthrough100enablingmetricdumping7encryptionconfigurationerrors31entriesdonotappear46errormessagesaccessdenied53BAP-ERR-000287BAPI-MDDATASET_CHECK_SYNTAX87CAM-CRP-106418CAM-CRP-1315Currentconfigurationpointstoadifferenttrustdomain32CAM.
AAA81CFG-ERR-0106CognosConfigurationreceivednoresponse11CGItimeout41,86CM-CFG-029ContentManagerisunabletodetermine36CM-CFG-503654CM-SYS-500754CM-SYS-506354CNC-ASV-000173CNC-SDS-0413Errorwhenexecutingascheduledreport59110IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuideerrormessages(continued)corruptcryptographicinformation35credentialsinvalid45cryptographicinformationcannotbeencrypted31DIS-ERR-3115Taskexecutionfailed41downloadofspecifiedresourcefails19DPR-ERR-201422DPR-ERR-2022Noresponsegenerated26DPR-ERR-2056reportservernotresponding6DPR-ERR-205820,24DPR-ERR-207937,98DPR-ERR-208278HRESULT72JavaRuntimeEnvironment35java.
lang.
StackOverflowError73MDS-RUN-3213Unabletolocatedatabasebulkloadutility41missingitems82MSR-PD-001266MSR-PD-001367OP-ERR-019962OP-ERR-020163ORA-0090780outofmemory87overflowerrorsincrosstabs79passwordexpired45,48PCA-ERR-005783PCA-ERR-008784PRS-CSE-125518QE-DEF-006853,93QE-DEF-017779QE-DEF-028553,93QE-DEF-028878QE-DEF-032553,93RQP-DEF-011428RQP-DEF-017783RSV-DR-000278RSV-SRV-002572RSV-SRV-004062RSV-SRV-006628SBW-ERR-002057SoapSocketException20SQLServercannotbefound53SQL1224N19tableorviewnotfoundindictionary81ThePageCannotBeFound91UDA-SQL-003153,93UDA-SQL-010753UDA-SQL-011472,79,83UDA-SQL-020672UDA-SQL-020853UDA-SQL-056483UDA-TBL-000479unabletoloadbalancetherequest22using5Webservicetaskmaximumstacksize73youhavechosentodownloadafile27errorsapplicationerrorsupgradingareport62certificateexpired46CNC-ASV-000758ESSBASEPATH38firewall98nullvaluesincountsummaries67outofmemory85parseerrorswithupgradedreports79errors(continued)recursiveevaluation83ESSBASEPATHadding38EventStudiocannotcalltheSDKfromEventStudio74CNC-ASV-0001java.
lang.
StackOverflowError73hyperlinksinemailmessagesarestrippedoutwhentheagentissaved73reportcontainsnodata73eventsviewingprogram,security,andsystems8Excelreportdoesnotopen84ExcelreportsAnalysisStudio80exceptionsunhandled6expiredpassword48externaldataMSR-PD-0012errorwhenimporting66MSR-PD-0013errorwhenimporting67Ffilteringtroubleshooting_make_timestampcolumns72filteringcascadingprompts107filtersQueryStudio78FixCentral2flicker42fontsnotfoundwhenstartingIBMCognosConfigurationonUNIX38FORclausesincorrectresultsforOLAP68formattingdisappearinginSSAS200590reportsshowunexpectedresults66forumsandcommunities3FrameworkManagercryptographicerror13Ggatewayconnectionissues33gatewayslogfile5recommendedsettingsforMicrosoftIIS41whentouseISAPI41groupingtroubleshootingincorrectrunningtotals90troubleshootingnestedlistreports62troubleshootingsubtotalsingroupedlists63groupsmissingmembershipinActiveDirectoryServer39HHRESULTerrors72HTMLadvancedfunctionality106printedreportunsatisfactory94HTTPmessageisunexpectantlyshort37Index111hyperlinksinemailmessagesarestrippedoutwhentheagentissaved73IIBMCognosAdministrationaccessdenied50IBMCognosAnalyticsresettingmobilesettingswhileupgrading106servicedoesnotstart14IBMCognosAnalyticsAdministrationtroubleshooting95IBMCognosAnalyticssamples9IBMCognosAnalyticsserverfailstostart14IBMCognosBIportalproblemconnectingon64-bitWebSphereApplicationServer33IBMCognosConfigurationchangingthesortbuffersize79fontnotfounderroronUNIX38invalidsettings15problemsopening4problemssavingaconfiguration28problemswithkeyboardnavigation34troublegeneratingcryptographickeysafterinstall32unabletostart34IBMCognosserviceservernotavailable15starting35IBMRedbooks3imagesdonotappearonUNIX105missinginPDFreport94notappearing107installationproblems11requirementsfordirectoryname23installationdirectoryproblemsafterrenamingormoving33installingIBMCognosAnalyticsonLinux28invalidcogstartup.
xmlfile35invalidsettingscontentstore15IBMCognosConfiguration15ISAPIwhentouseforagateway41JJapanesecharacterscorruptduringinstallationonLinux26JapaneseInternetExplorerAnalysisStudio80jarfileerrorwhenstartingconfiguration35JavasupportedversionsforDb2contentstore14usesallofCPU14Javaerrortroubleshooting58Javaerrorwhenstartingconfiguration35Javavirtualmachinecrasheswhenimportingdeployment37JAVA_HOMEsetting35java.
lang.
InternalError106java.
lang.
NoClassDefFoundError13,106Kkeyboardnavigationproblems34knowledgebases2KoreancharacterscorruptduringinstallationonLinux26Llanguagesmixedwhenusingsamples81OLAPdatasources77linksbrokenfollowingdeployment57unabletoclick93Linuxcharactersnotdisplayedproperly28corruptcharactersduringinstallation26LinuxonSystemzC8DB2.
shscripterror36listpromptssinglespacesnotsupported105listssubtotalsingroupedlists63localesmissingtranslationsofobjectnames42logdatabasedeletingtables29logfiles3gatewayerrors5installationconfiguration4localeconfiguration4run-time5silentmode5startupconfiguration4transfer4uninstallation5logginglevelsaffectingperformance56logonproblemsSAPnamespace47,48Mmetricdumpfile7troubleshooting7metricstoresfailure41Microsoftsecurityupdateaffectsmemory14MicrosoftCube23MicrosoftIISWebserversrecommendedgatewaysettings41MicrosoftRegistryEditorincreasingsocketsorports40MicrosoftSQLServercreatingdatasourceconnections54missingitemstroubleshooting82mobileclientproblems107112IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidemobileserviceproblems105mobilesettingsresettingwhileupgradingIBMCognosAnalytics106MSR-PD-0012errors66MSR-PD-0013errors67multipleformatsunabletoselect81Nnamedsetsnestedorparallelsetsoverlapping63namestruncating108namespacesActiveDirectoryServermissinggroupmembership39cannotlogon18recreating34nestedcrosstabonlyfiltersonsomeitemstroubleshootingdrillingthrough100nestedlistreportsnotrunningafterupgrading62nestedsetsunexpectedsummaryvalues67networkoutageservicesfailtostart19noresponsegenerated26non-Englishcharactersappearasplaceholders91notificationdatabasedeletingtables29NTLMnamespaceaccesstoIBMCognosAdministrationdenied50nullvaluescalculationswithSAPBWdatasources67troubleshootingincountsummaries67OODBCdatasourceconnections54OLAPdatasources23languages77membersmissingorinaccessible39OLAPsourcecannotconnect54OP-ERR-0199errors62OP-ERR-0201errors63ORA-00907errors80OracleCM-CFG-506354CM-SYS-500754CM-SYS-503654contentmanagerconnection54deploymenterrors41OracleApplicationServerdeploymentfailure28Oracledatasourcestroubleshooting80OracleEssbasechanges63queryfails40OracleEssbaseversion11settingsubstitutionvariablesinIBMCognos858outofmemoryerrorsinHP-UX87OutOfMemoryError20outputfilessystemmetrics7overflowerrorsincrosstabs79Ppagebreaksunexpectedresults77parameterignoredtroubleshootingdrillingthroughtoPowerPlayStudio99passwordexpired45passwordsexpired45SAPnamespace47PCA-ERR-0057errors83PCA-ERR-008784PDFproblemscharts94missingimagesinreport94percentagevalues78performancelogginglevel56portalerrorsinstarting24,26portalproblems93unabletoclicklinks93unabletoopen24portsalreadyinuse14PowerCubescannotopen23errorwhencreatingdatasourceconnections55incorrectresults70troubleshootingdrillingthrough98PowerPlayStudiocrosstabdisappears92printingreports94missingimagesinPDF94troubleshooting75unsatisfactoryresultswhenprintingHTMLreports94ProblemManagementReportslogging2PMRSeeProblemManagementReportsproblems,Seetroubleshootingpromptsincorrectcalendarresults107problemswithfilters107singlespacesnotsupportedinlists105QQE-DEF-0068errors93QE-DEF-0177errors79QE-DEF-0285errors93QE-DEF-0288errors78QE-DEF-0325errors93querycalculationsnullvaluesincountsummaries67RrecreatingtheCognosnamespace34relationaldatasourcesmembersmissingorinaccessible39Index113relationalreportingtroubleshootingdrillingthroughtocubes97renderingrepeatertables107repeatertablesrenderingincorrectly107reportcontainsnodata73reportdistributionproblems72reportlinkinemailnotificationdoesnotwork72reportservicesadvancedsettings91Reportingtroubleshooting95reportschangingthemaximumnumberoftuplesallowed84containsnodata73formattingchangeswhenupgrading89notvisiblefromdevices108outofmemoryerrorsininteractiveHTMLoutput85requirementsinstallationdirectory23round-offerrors71RQP-DEF-0177errors83RSV-DR-0002error78RSV-SRV-0025errors72RSV-SRV-0040errors62RSV-SRV-0063errormessage37runningreportscannotfinddatabaseerrors78DPR-ERR-2082errors78notrunningasexpected79ORA-00907errors80performanceproblems86QueryStudioisslow87querytakeslongtimetofilternon-ASCIItext87Reportingisslow87scheduledreportsfail81tableorviewnotfoundindictionary81troubleshooting75unabletoselectmultipleformats81runningtotalstroubleshooting90SSafariWebbrowsersdrill-throughlinksnotactive96samplestroubleshootingmixedlanguages81using9SAPpasswordpolicy47SAPBWerrorsrunningreports57unabletoidentifySAPpermissions49unabletoidentifyversion57usingnon-ASCIItextvalues87SAPBWdatasourcesauthenticationproblems51nullresults67querycalculations67sectioningreports64SAPnamespacelogonproblems47,48repeatedpromptsforauthentication48screenflicker42scriptstodeletetablesfromdatabases29SDKcannotcalltheSDKfromEventStudio74sectionscreatingonreportswithSAPBWdatasources64securityaccesstoentriesdenied45accesstoIBMCognosAdministrationdenied50changepasswords45credentialsinvalid45entriesdonotappear46events8passwordexpired45problems45problemsloggingontoanSAPnamespace47settingup45unabletologon45servicerequestsPMR2servicesfailtostartafternetworkoutage19unabletostart14setsofmembersnestedorparallelsetsoverlapping63settingsresettingwhileupgradingIBMCognosAnalytics106singlesignonaccesstoIBMCognosAdministrationdenied50SOAPresponseerrorwhenviewingreportoutputsfromemaillink91softwaresupportandRSSfeeds3SQLscriptstodeletedatabases29SQLServercannotbefound53cannotconnectusingOLEDBconnection53creatingdatasourceconnections54SSAS2005cubestroubleshooting65SSAS2005datasourcesdisappearingdataformats90startupconfigurationlockfile4Db2returnsSQL1224NerrorwhenconnectingfromAIX19downloadofresourcefails19failurewithouterror14IBMCognosservice35problems11scriptfails27unabletodownloadcognos.
xts27unabletostartservice14studiosOracleEssbasechanges63substitutionvariablesOracleEssbaseversion1158subtotalstroubleshootingingroupedlists63summariesFORclauses68troubleshooting75summaryvaluesunexpectedwhenusingnestedsets67SupportPortal2systemevents8114IBMCognosAnalyticsVersion11.
0.
0:TroubleshootingGuidesystemmetricsoutputfile7systemstartupservicefails106TTabkeyproblemsinIBMCognosConfiguration34tableorviewnotfoundindictionaryerrors81tablesdeletingfromadatabase29notvisible106targetdoesnotfilterproperlytroubleshootingdrillingthrough100templatesbackgroundcolorsnotappearing63temporarydirectoriesdeletingbeforereinstall32testingcomponents9texttruncating108TM1datasourcesorderofmetadatatree66reportdifferences66totalstroubleshootingrunningtotals90troubleshootingdrillingthrough95troubleshooting105AnalysisStudio95authoringreports61CognosDiagnosticUtilities2ContentManagerfailstostart20databasetablesnotcreated106differencesintheappearanceofchartsrunindifferentformatsorondifferentoperatingsystems84distributingreports72forumsandcommunities3gettingfixes2IBMCognosAnalyticsAdministration95IBMRedbooks3identifyingproblems1metricdumpfile7mobileclient107mobileservice105outofmemoryerrorswithreportsrunininteractiveHTML85provenpracticesdocumentation3Reporting95running,viewing,orprintingreports75SAPBWdatasources51softwaresupportandRSSfeeds3SupportPortal2systemstartup106usersarenotreceivingburstreports108troubleshootingresources2truncatingnames108text108trustdomainerrorwhensavingtheconfiguration32tupleschangingthemaximumallowedinreports84UUDA-SQL-0031errors93UDA-SQL-0043errors83UDA-SQL-0114errors72,79,83UDA-SQL-0129errors93UDA-SQL-0206errors72UDA-SQL-0564errors83UDA-TBL-0004errors79unabletoopenIBMCognosConfiguration4unexpectedresultspagebreaks77unexplainednumbercalculations71unhandledexceptionsdiagnosing6unicode91UNIXchartsandimagesdonotappear105creatingdatasourceconnections54fontnotfounderror38unsupportedcharacters15updaterequestfails55,56upgradingcontentstore19missingtranslationsofobjectnames42problemswithcryptographickeys32upgradingreportsapplicationserrors62formattingnotretained89reportswillnotopen79wordwrappinginPDFoutputs89usersnotreceivingburstreports108Vvaluespercentage78videodocumentationYouTube2viewingevents8viewingreportsSOAPresponseerrorwhenviewingfromemaillink91troubleshooting75,82,89WWebbrowserserrorsinstartingtheWebportal26errorswhenstartingthewebportal24WebSphereApplicationServerIBMCognosAnalyticsdeploymentfailure28problemconnectingtoIBMCognosAnalyticsportal33startupscriptfails27WindowsEventViewer8WindowsIISrecommendedgatewaysettings41wordwrappinginPDFoutputsupgradingreports89wrongdataappearsintargetreporttroubleshootingdrillingthrough101XXQE-DS-000640Index115