OFSAA Troubleshooting Guide
Contents
1. eroteeneneeteneeneneeteneenenee 1 6 1 15 Extract Transform Load Reference No 14598003 meeeteeneneneneeneneteneenenae 1 7 1 16 Extract Transform Load Reference No 14777063 ceouuusmusen ue ee e e e neen 1 7 1 17 External Scheduler Interface Component Reference No 15935135 onccccccininnonoconononononos 1 8 1 18 Filters Reference No 14097329 ceuuuuuuumuu menne ene ee e e a a ana a a an aa a eaa nono 1 8 1 19 Forms Framework Reference No 13895430 e oteeneneneneeneneenenaetenaenenante eanet 1 8 1 20 FormsFramework Reference No 14260288 0 romsetereereranenateteenenaete omette 1 9 1 21 Forms Framework Document Upload Reference No 16089350 rrrrrrnrrvrvvrvrvrvrrvrrrene 1 9 1 22 Information Command Center Reference No 14194062 meroreereneeteenerenee 1 9 1 23 Information Command Center Reference No 14605056 mrenenenenenene 1 10 1 24 Information Command Center Reference No 14621192 mnrennnenenenete 1 10 1 25 Information Command Center Reference No 14648934 rnrenenenenenete 1 10 1 26 Information Command Center Reference No 14848627 mmmenenenenenene 1 11 1 27 Information Command Center Reference No 15938239 1 11 1 28 Information Command Center Reference No 160344592. mutnrerenereneneneete 1 11 1 29 Installation Reference No 14235252 treteneneneneneteonene a e a e ana nene nete nene 1 12 1 30 Installation Reference No 14663973 wtoereeneneeneteeneteeneneonenenene nne eaa cnn 1 12 1 31 Installation Reference No 14750228 J renrnavnnnrvnrnrvnverenenrenensenensenesrenesrenerrenensenessenessenenne 1 12 1 32 Logger Module Reference NO vuuussuu uses ee e eee e e e esseen 1 13 1 33 Logger Module Reference NO uuuuuuumusss emmma anta a am ta eee ee esseen 1 13 1 34 Metadata Archive Restore Reference No 15872162 1 13 1 35 Metadata Browser Reference No 14737387 wotoeneeeneeneneeneteeneneeneneeneneene nene 1 13 1 36 Z PR2 Reference No 16041012 maa a e a aa e aa a enene nene enene nene nene enene nene 1 14 1 37 PR2 ICC Reference No 15829196 etinio e e e e e e ea e a na a na ne annan een 1 14 1 38 Security Management System Reference No 14609722 1 14 1 39 Security Management System Reference No 14634120 mrresnnenensenanenenete 1 15 1 40 Security Management System Reference No 14490084 srsnrvrvrerererererereresereveresesereverer 1 15 1 41 Security Management SSO Reference No 14847598 1 16 1 42 Setup and Maintenance Reference No vuuussuss ss eee e ne e eee 1 16 1 43 Setup and Maintenance Reference No 16089317 srsnrvrvrvrvrerererererere
3. again from source environment and restore it If this issue persists contact Oracle Support 1 2 Product Title BookTitle as a Variable Common Apps 1 5 Business Metadata Management Table 1 5 Business Metadata Management Reference No 14477940 Problem Details Description While saving the cube the following error message appears 4510 Error while File Transfering FTP Cause Memory Configuration Type Environment Solution Verify with the Sun Java Console if the memory exception appears If yes then change the Java Run Time parameters 1 6 Common Apps Table 1 6 Common Apps Reference No 13789810 Problem Details After installing FTP ALM and PFT applications deploy the ear file Login to OFSAA and go to Financial Services Applications screen The following error message appears javax servlet ServletException Filter struts2 could not be Description initialized Cause Struts xml not updated Type Configuration Solution The size of the struts xml must be 0 byte Verify the size from the following location OSFIC WEB HOME webroot WEB INF classes struts xml file Troubleshooting of OFSAA Infrastructure 1 3 DeFl 1 7 DeFl Table 1 7 DeFI Reference No 14049662 Problem Details In the Data Entry screen when you click the existing form under OFSAA application you see a blank screen The following error message app
4. Library a OFSAAI 7 3 3 0 0 User Manual OFSAAI Administration Guide OFSAAI7 3 3 0 0 Installation Guide UNIX and Windows Conventions The following text conventions are used in this document Convention Meaning boldface Boldface type indicates graphical user interface elements associated with an action or terms defined in text or the glossary italic Italic type indicates book titles emphasis or placeholder variables for which you supply particular values monospace Monospace type indicates commands within a paragraph URLs code in examples text that appears on the screen or text that you enter Contents PICO TSN ii AUdIONCO nu cextezente tans reets karikas aaa a a k ngu leiste leelo dau katus dd aid iii Documentation Accessibility vivien samana a vin loves S SOTAA kee Sua eua a Sepa lone ge iii Related Documents acido cid ee ei ibe ee ta ot a fanaa iii Conventillo TS iii 1 Troubleshooting of OFSAA Infrastructure 1 1 Administration Object Migration rerrrrvvrrrervrrrrervrrrererrrerersrsreserererersreseserssesesevereseseseserene 1 1 1 2 Application ld a li 1 1 1 3 Application Web Server cial nm es e a aaa De NET ekan 1 2 1 4 ATchivo Restore die 1 2 1 5 Business Metadata Management vusousosnss sosi see e ea nene ee e e e e ease 1 3 1 6 COMMON Apps mutaan a aeaa HT rias 1 3 1 7 DeE uns A ISEN AN S A MSS S SSI Nai 1 4 1 8 DeFi Excel Upl oad iii saama sera eek De pe Se 1 5 1 9 Envir
5. Reference No 14490084 Problem Details Description In OFSAAI 7 3 when you login as a new EPM user the following error message appears WARNING 14870 You are not Authorized to access this Page Please Contact System Administrator Cause To login to OFSAAI you must have the following priviliges 1 Login must be mapped to at least one INFODOM and you must be authorized 2 You must be mapped to enough privileges to login to application Type Environment Solution Verify if you are mapped to the InfoDom User Role Troubleshooting of OFSAA Infrastructure 1 15 Security Management SSO 1 24 Security Management SSO Table 1 41 Security Management SSO Reference No 14847598 Problem Details OFSAA application configured with SSO credentials is locked and the following error message appears Description Please Contact System Administrator Cause Password expired in LDAP Type Login Solution For SSO login you must use the LDAP password link Or Contact Oracle Support provide the necessary details and get a new password 1 25 Setup and Maintenance Table 1 42 Setup and Maintenance Reference No Problem Details How to ensure that App Server and Web Server are Description communicating properly Cause Type Health Check Solution From FICWeb cfg file in FIC_ HOME fiapp common FlCServer conf verify if SERVELET_ URL appears in the b
6. as a Variable Environment 1 8 DeFi Excel Upload Table 1 10 DeFi Excel Upload Reference No 14675268 Problem Details Description Excel upload fails with the following exception com sshtools j2ssh transport TransportProtocolClient verifyHostKey The host key was not accepted par Cause Communication between two servers does not occur because of absence of entries in known hosts file Type Environment Solution Perform the following steps 1 Take a back up of known hosts file from lt APP ROOT gt ssh location and then delete the known hosts file 2 Stop the Reveleus Server 3 Start the Reveleus in foreground and keep the console ready 4 Login to Revelus and save the latest App Server details through SystemConfiguration Server Details Application Server 5 Click Save The following message appears in the App Server Console Do you want to allow this host key Yes I No Always 6 Click Always and press Enter A message appears Successfully Saved The known_hosts file is generated in lt APP_ROOT gt ssh folder 7 Copy known_hosts file to lt WEB_USER gt ssh Restart the Reveleus and Webserver 1 9 Environment Table 1 11 Problem Environment Reference No 16039589 Details Description Unable to start the servers in Sun Solaris The following error appears ClassFormatError for sun security x509 OIDMap Cause JAVA HOME must not
7. be set in profile Type Setup and Maintenance activity Solution Java Library files must be corrupted Reinstall Java and check again Note that in Sun Solaris systems JAVA_HOME must not be set in profile Troubleshooting of OFSAA Infrastructure 1 5 Excel Upload Table 1 12 Environment Reference No 14137258 Problem Details Description When trying to open OFSAAI URL the following error message appears The security certificate presented by this website was issued for a different website s address Security certificate problems may indicate an attempt to fool you or intercept any data you send to the server We recommend that you close this webpage and do not continue to this website Cause SSL configuration not done correctly by defining in web server Type SSL configuration Solution This is not an error Itis a secure protocol https URL which displayes that message Click Continue to Website and proceed It can be resolved permanently by addinga secure certificate in the Trusted root site 1 10 Excel Upload Table 1 13 Excel Upload Reference No 13635746 Problem Details While loading Excel Upload gt Excel Entity gt Mappings spreadsheet data does not load and the following exception is created in webserver console log Do you want to allow this host key Yes I No Always Description java lang NullPointerException Cause Host Key G
8. ALLCONFIG xml For example DBCOMP_IP and DBSERVER values Verify if the value of NLS_LENGTH_SEMANTICS is given with CHAR Table 1 30 Installation Reference No 14663973 Problem Details Description While performing pre installation activities of Basel IT Modules it is identified that patch number 7 3 1 0 must be installed The following error message appears while applying the patch on the DB Tier TOFSAAIUPDATE 2012 09 23 18 46 41 315 Performing precheck OFSAAIUPDATE 2012 09 23 18 46 42 896 Current Servicepack Level 7 3 Cause Configuration Type Installation Solution Verify if params conf is updated with correct values Table 1 31 Installation Reference No 14750228 Problem Details While installing OFSAAI the following error appears Description Total file descriptors for the user cannot be less than 3096 Cause File descriptor count must be increased Type Environment Solution Verify the total file descriptor using ulimit n command Increase the total number of file descriptors by edit etc security limits conf with username hard nofile 5000 number of open files Example username hard nofile 3096 or username soft nofile 3096 1 12 Product Title BookTitle as a Variable Metadata Browser 1 18 Logger Module Table 1 32 Logger Module Reference No Problem Details Description Logs not updating in the APP and Web Layer C
9. ORACLE Financial Services Analytical Applications Infrastructure Troubleshooting Guide Release 7 3 3 E48645 01 September 2013 Financial Services Analytical Applications Infrastructure Release 7 3 3 E48645 01 Copyright O 2013 2012 Oracle and or its affiliates All rights reserved Primary Author Swathi Vijayanand G Contributing Author Gitcy Paulose Contributor Sri Krishna D R V P P Raju This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing If this is software or related documentation that is delivered to the U S Government or anyone licensing it on behalf of the U S Government the following notice is applicable U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation d
10. ause Logger related files not configured correctly Type Configuration Solution Verify if LOGS folder exist in FIC_ HOME ficapp common FICServer and WEB_SERVER_ HOME lt context gt locations If logs folder does not exits then create it and restart the servers and check again In addition verify the path given for each Logger RevLog4jConfig xml in FIC_HOME conf and WEB_ SERVER HOME lt context gt conf If it is incorrect then update them and then restart the servers and check Table 1 33 Logger Module Reference No Problem Details Description How to send logs to support when issues are found in OFSAA Cause Type Environment Solution 1 19 Metadata Archive Restore Table 1 34 Metadata Archive Restore Reference No 15872162 Problem Details In the Archive Metadata screen after mapping you click Finish In the status message it appears as undetermined There is a Description null pointer exception with respect to filter servlet Cause Web xml Type Configuration Solution Verify the Filter Servlet configuration in web xml To validate open web xml in Internet Explorer and check if it opens correct the same and check the issue If this issue persists contact Oracle Support 1 20 Metadata Browser Table 1 35 Metadata Browser Reference No 14737387 Problem Details Description Unable to view the Mapping and Metadata browser screen Ca
11. e AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices UNIX is a registered trademark of The Open Group This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services Audience Preface This guide has been developed with the interest to help you resolve some of the issues faced while using OFSAAI This guide is intended for the Information and Business Analysts who are instrumental in supporting and affecting analytical decisions Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http www oracle com pls topic lookup ctx acc amp id docacc Access to Oracle Support Oracle customers have access to electronic support through My Oracle Support For information visit http www oracle com pls topic lookup ctx acc amp id info or visit http www oracle com pls topic lookup ctx acc amp id trs if you are hearing impaired Related Documents For more information see the following documents in the OTN
12. ears Description Error 500 java lang ExceptionInInitializerError Cause DeFI home path is not set in the configuration table Type Configuration Solution Verify the DeFI home path in configuration table It must point to the DeFI folder in the deployment location DeFIHome WEBSERVERHOME lt context gt ear lt context gt war DeFI Table 1 8 DerFl Reference No 14136338 Problem Details After exporting data from any form through Data Entry screen it is not possible to import the same to another form through Description Excel upload utility because of different date formats Cause Understanding Error Type Understanding Error Solution As DeFl always uses MM DD YYYY format use MM DD YYYY as Source Date format in the Excel Mapping screen and get the excel feed in MM DD YYYY format Or Create two Excel Mappings 1 Source Date format as DD MM YYYY 2 Source Date format as MM DD YYYY Use the excel mapping 1 for external excel feed and use excel mapping 2 for DeFI module export excel sheet Table 1 9 DeFI Reference No 14243028 Problem Details After you create a new Form and map a user to that form you Description are unable to see the form in data entry screen Cause Understanding Error Type Usability Solution Verify if the form is defined with authorization If it is not authorized then authorize the form to the user it is mapped to 1 4 Product Title BookTitle
13. elivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate fail safe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International Inc AMD Opteron the AMD logo and th
14. ema might not be a part of DataBAse xml Datamodel Type Configuration Solution Check if the underlying table for the hierarchy definition is present in the OFSAAI system DATABASE xml Verify your datamodel and then make necessary changes if needed Table 1 48 Unified Metadata Manager Reference No 15910337 Problem Details After you add a new measure and restart the service the Metadata Loading for lt infodom name gt Infodom takes 20 40 minutes When you delete a measure Metadata Loading for lt infodom Description name gt Infodom takes 50 seconds Cause Configuration is incorrect with respect to measure cache Type Performance Solution Increase the measure cache to 2000 in DynamicServices xml and then restart the servers The file is located at lt FIC_ HOME gt conf applayer For example lt PARAMETER NAME MEASURE_CACHE_ SIZE VALUE 2000 gt Note Ensure to take a back up of all the files before replacing them 1 29 Usability Table 1 49 Usability Reference No Problem Details When trying to access OFSAA Login window It says page Description cannot be displayed and an error appears in browser Cause Setup and Maintenance Type Setup and Maintenance Solution Verify if the web server is started Check if multiple instances are running using ps ef grep LOGNAME In addition check web server logs error trace In case you not unable to find a so
15. eneration Type Environment Solution Perform the following steps 1 Start the Tomcat server in foreground mode 2 Load the Excel Entity Mapping screen where the problem occurs 3 Check the Tomcat console screen The following message appears Do you want to allow this host key Yes No Always 4 Click Always 1 11 Extract Transform Load Table 1 14 Extract Transform Load Reference No 14030180 Problem Details During the data load in T2T how does DISABLEPRIMARYKEY Description work for Batch and Bulk Mode and Direct Mode 1 6 Product Title BookTitle as a Variable Extract Transtorm Load Table 1 14 Cont Extract Transform Load Reference No 14030180 Problem Details Cause Query Type Query Solution For Bulk Mode If PROPERTY DISABLEPRIMARYKEY Yes the PK gets disabled before loading For Batch Mode If PROPERTY DISABLEPRIMARYKEY Yes it does not work Table 1 15 Extract Transform Load Reference No 14598003 Problem Details The following conversion occurs in OFSAA as product functionality For example Table FCT_LSS_BASEL_EXTRACT_AGREEMENT_201 20531 Column D_F_START_DATE In the column D F START DATE the value 0009 of source file gets converted as 2009 in DWH Table FCT LAG BASEL EXTRACT AGREEMENT Column MATURITY DATE Misdate 20120614 In the column MATURITY DATE the value 0002 of source file Description gets conver
16. fter the other It is possible to edit one Tree Filer and save the changes successfully However when you start editing the second Tree Filter and click Save the interface pauses You have to close all the web browser windows and clear the cache before Description logging into OFSAA again Cause Incompatible browser version Type Internet Explorer Solution Verify the Internet Explorer version and correct the same as mentioned in the Installation Manual 1 14 Forms Framework Table 1 19 Forms Framework Reference No 13895430 Problem Details While opening a page script in Forms Framework the following error message appears in the Internet Explorer status bar Description Undeterminated string constant Cause URL control is not configured Type Configuration Solution Verify if control value assigned to URL control which contains special characters causes this type of issue In general URL CONTROL is like ACTION CONTROL For example ADD EDIT link It does not hold any value of text field text area Change the URL control configuration and try again 1 8 Product Title BookTitle as a Variable Information Command Center Table 1 20 Problem FormsFramework Reference No 14260288 Details Description After editing a field in Business Restructure screen if you try to edit it again you get the following error message Unable to update as the record is concurrently modified by anothe
17. is Description unavailable Cause User Privileges Type Environment 1 14 Product Title BookTitle as a Variable Security Management System Table 1 38 Cont Security Management System Reference No 14609722 Problem Details Solution Refer to SMSService log from FIC_APP_ HOME common FICServer logs and check if you find an error like this Use does not have access to the Folder name lt folder name gt If yes verify cssms_folder_function_map table from config schema to find if the entry is there for the folder In addition check if the function associated with the folder is mapped to login user Verify if app web db layer users have permissions on ftpshare folder Table 1 39 Security Management System Reference No 14634120 Problem Details When trying to remove a group from a User Java NULL Pointer exception is given The exception details are as follows om ibm ws webcontainer servlet ServletWrapper service SRVE0068E Uncaught exception created in one of the service methods of the servlet SMSServlet in application mantas61 Description Exception created java lang NullPointerException Cause Ear file was not generated with latest files Type Usability Solution Verify if the Web xml is correct in case you have recently applied a patch After applying a patch you must redeploy ear file in web server as mentioned in readme txt Table 1 40 Security Management System
18. lution contact Oracle Support 1 18 Product Title BookTitle as a Variable A Administration Object Migration 1 1 Application 1 1 Application Web Server 1 2 Archive Restore 1 2 B Business Metadata Management 1 3 C Common Apps 1 3 D DeFl 1 4 DeFi Excel Upload 1 5 E Environment 1 5 Excel Upload 1 6 External Scheduler Interface Component 1 8 Extract Transform Load 1 6 F Filters 1 8 Forms Framework Document Upload 1 9 FormsFramework 1 8 Information Command Center 1 9 Installation 1 12 L Logger Module 1 13 M Metadata Archive Restore 1 13 Metadata Browser 1 13 Index p PR2 1 14 PR2 ICC 1 14 S Security Management System 1 14 Security Management SSO 1 16 Setup and Maintenance 1 16 SSO 1 16 U UMM PR2 1 17 Unified Metadata Manager 1 17 Usability 1 18 Index 1 Index 2
19. nformation Command Center Reference No 15938239 Problem Details Description Load data tasks fails with an error Invalid Date Format Cause Data format is incorrect Type Operational Solution Verify if the date format given for Database name is different from that of Database server date format In case this issue persists itis recommended to contact Oracle Support Table 1 28 Information Command Center Reference No 16034459 Problem Details DT execution fails As per am_log log am server is not able to communicate with router following is the error from log 2012 12 20 12 58 20 AM SEVERE AM_Reg Call to SocketClient Connect Failed Discarding Message 2012 12 20 12 58 20 AM SEVERE AM Failed to Description register with Router s Cause Servers not ruming Type Operational Solution Verify if all the ICC RAM servers are running Restart the servers and check again Troubleshooting of OFSAA Infrastructure 1 11 Installation 1 17 Installation Table 1 29 Installation Reference No 14235252 Problem Details When installing OFSAAI in GUI mode the following error appears Error OFSAAI 1150 java sql SOLException The Network Adapter could not Description establish the connection Cause Configuration error with inadequate values Type Configuration Solution Verify if APP WEB DB IP address have correct values in the OFSAAI_INST
20. ninininnicncncnos 1 1 1 2 Application Reference No 14686382 r nrererer ere vrerererererererererersresererereseseseseresesesesereserssesere 1 1 1 3 Application Web Server Reference No 14675705 rnnnnnnrnrnvoverersvrrrrnerersrsrrrrerenveverevrnsnnr 1 2 1 4 Archive Restore Reference No 16082439 rrsnnrnrnrvnrnnvnrvavnrvavnsvavnsvevesvasesvavesvevsevasesvavesrere 1 2 1 5 Business Metadata Management Reference No 14477940 rsesererervrererererereseresereversseserer 1 3 1 6 Common Apps Reference No 13789810 srrervrererervrvrerereserereresesererereresesererersseseseresssesesennr 1 3 1 7 DeFI Reference No 14049662 00 tes sescsscceeeeecceecseeseseesecersesessecesseseseseesecesseseseesessenesee se 1 4 1 8 DeFI Reference No 14136338 a aaia iit A E ee 1 4 1 9 DeFI Reference No 14243028 soonnnnoroonorernererraresraresrarverarsenerveransevennevensenesrenesrenesrenesravesnere 1 4 1 10 DeFi Excel Upload Reference No 14675268 ococioiocoonononicnonaraninononanananononononanononononononanononos 1 5 1 11 Environment Reference No 16039589 coococcococcocicnococnononnononnnnonanaonnnnonnn conan conan none ea eanet 1 5 1 12 Environment Reference No 14137258 ccoocccocicnocicnocconononnnnonnnnonnn conan conan conan conan none ena eanet 1 6 1 13 Excel Upload Reference No 13635746 uvuuuussssuu esseet en eee e eee neen 1 6 1 14 Extract Transform Load Reference No 14030180
21. onment iuge dE lv BDA ANEELA sensa ae Taka kka kansaa AN ENAA kaa kps as I Ks Orlau el vat Lk vean EE See 1 5 1 10 Excel Uploadaa ES MTA n o aa 1 6 1 11 Extract Transform Load ii SR a MAN ENS na n us 1 6 1 12 External Scheduler Interface COMPOMENE cee au ee ne e e e eee 1 8 Wide A aN NHTV RN 1 8 1 14 Forms Frameworks N vasaransa le maana 1 8 1 15 Forms Framework Document Upload 1 9 1 16 Information Command Center suussmsnn ss aa a a aa aan aa a aa ea aa a nan aeeeen 1 9 TAF gt Installation m E S EIKA ESIT ATA I q act ETA minta 1 12 1 18 L sser Modules sakna ee 1 13 1 19 Metadata Archive Restore wwreusseeeeesseeneeetsenaneneesseeesest eas aneee enaa oon ata eito nia 1 13 1 20 Metadata Browse A Joe are va ULE 1 13 1 21 PR2 ee OS AA 1 14 1 227 PRY MCC indie a tet Moves tein ease ease 1 14 1 23 Security Management System rrrvrvrvarvrrrvevrrererverevevsresverenesersrvenevessrssveveserssseveserssssssvevesessnne 1 14 1 24 Security Management SSO i1vui ssivsms ain ajelin sa jake chest repa iiair Saini iaie ai 1 16 1 25 Setupsarid Maintenance camas hesu usa aaau iei 1 16 1 26 AA O 1 16 1 27 UMMI PR SED 1 17 1 28 Unified Metadata Manager cccccccsccccesssssesesescscsesesescscssseseecscsssssesescecsssnseesececesessnesecesenes 1 17 1 29 Index vi Usability vii List of Tables 1 1 Administration Object Migration Reference No 14678679 oononcicicicinnnoni
22. ot be kept in protected 1 27 UMM PR2 Table 1 45 UMM PR2 Reference No 16033614 Problem Details Description Unable to open Rule Run Hierarchy Cause Improper Metadata Type Metadata Solution Check if 0 version of metadata entries are present in Metadata tables in config schema Ensure that the version match and O version entries are present in Metadata_ tables in config schema and Rev_bihier Rev_ Locale_hier tables from atomic schema 1 28 Unified Metadata Manager Table 1 46 Unified Metadata Manager Reference No 13680692 Problem Details Description When you try to edit a function from Post Load Transformation the actual database function is not updated Cause Definition Mis match Type Implementation Error Solution The UI function and the executed function are different It is recommended to verify if the UI and Database function are same Troubleshooting of OFSAA Infrastructure 1 17 Usability Table 1 47 Unified Metadata Manager Reference No 14118563 Problem Details Description In OFSAAI while saving the Metadata in Administration gt Save Metadata the following errors message appears Details Amount 3829 Unknown error Business Type for Account Level Profitability 8829 Unknown error Consolidation 4520 Metadata could not be parsed Please check SQL syntax Cause Each table that exists in atomic sch
23. r user Cause Forms Configuration Type Forms Configuration Solution Concurrency check field value does not refresh after a save and it fails to update for the second instance Check if the configuration for Container Refresh is implemented for Hierarchy Maintenance Form after you click Edit and click Save 1 15 Forms Framework Document Upload Table 1 21 Problem Forms Framework Document Upload Reference No 16089350 Details Description When trying to upload a document an error message appears Document Upload failed ORA 04063 view ACCROR100 DOCUMENT MASTER has errors Cause Web server user does not have read write permissions on ftpshare Docstorage folder Type Usability Solution Read write permissions to be given for web server user on docstorage upload and download folder in ftpshare 1 16 Information Command Center Table 1 22 Information Command Center Reference No 14194062 Problem Details Description Batch shows an ONGOING status in Batch Group Monitor where as it shows as failed in BATCH MONITOR Cause Not executing a specific batch in a batch group using appropriate command Type Usability Solution Verify if the batch group is invoked from ESIC If yes check if entire batch group is executed There is an option to execute only selected batches in a group For more information refer ESIC Doc
24. rererererersresererssesesener 1 16 1 44 SSO Reference No 16084717 emeeeneneoneneneneoneneonennereneenenneneneeneneetenaenenee nene een 1 16 1 45 UMM PR2 Reference No 16033614 sotereneoneneeneneoneneeneneoneneeteneeneneeteneete 1 17 1 46 Unified Metadata Manager Reference No 13680692 1 n n0n6tsnensnsnenerensnsnsnenens 1 17 1 47 Unified Metadata Manager Reference No 14118563 vuuuuussu uus 1 18 1 48 Unified Metadata Manager Reference No 15910337 rrrrrrnrrvrrrvrvrrrvvrrerersrerersresererssesener 1 18 1 49 Usability Reference No vuuuvumss seem ee eee e eee ee e ee cono rara raras 1 18 viii 1 Troubleshooting of OFSAA Infrastructure 1 1 Administration Object Migration Table 1 1 Administration Object Migration Reference No 14678679 Problem Details When you try to execute a dimension Object Migration rule between two INFODOMS in the same instance the following error appears in the Web Apps FUSIONSUBSYSTEMSService log FUSIONSUBSYSTEMS Sep 20 12 09 46 03 COMMONFUNCTIONSIError whileconnecting java net ConnectException Tried all 1 addresses but could not connect over HTTP to server Description 10 7 243 9 port 7007 Cause Environment Type Environmental Solution Check if all conf files web xml LookupServices xml are configured using hostname instead of IP If it is with hostname and you are tr
25. rowser It displays the list of services that are running on appserver In addition verify if java port and native port values have the same values with which the setup is maintained Table 1 43 Setup and Maintenance Reference No 16089317 Problem Details Unable to open the Metadata Browser screen An error message appears whether trust the publisher or not Even though Description Always Trust is selected this error message still appears Cause SSL configuration is incorrect Type SSL Configuration Solution A problem exits with SSL Certificate You must configure SSL Certificate for the app 1 26 SSO Table 1 44 SSO Reference No 16084717 Problem Details When trying to access through direct_login jsp it opens the correct SYSADMN SYSAUTH window In case the SYSADMN Description password is entered it opens the SSO window 1 16 Product Title BookTitle as a Variable Unified Metadata Manager Table 1 44 Cont SSO Reference No 16084717 Problem Details Cause SSO configuration is incorrect for direct_login jsp Type SSO Login Solution The resources are protected at the context level and only the direct_login jsp is excluded from protection Use the Tomcat URL to access the direct_login jsp instead of using the Apache URL to login without SSO Or Protect the login jsp and prelogin jsp with SSO It means protection must exclude direct_login jsp must n
26. running correctly using command ps ef grep LOGNAME If any process is not displayed in the output of the above command restart all the above mentioned servers and try executing the batch Table 1 25 Information Command Center Reference No 14648934 Problem Details Description Unable to get Start and End Time for each task by Batch ID 1 10 Product Title BookTitle as a Variable Information Command Center Table 1 25 Cont Information Command Center Reference No 14648934 Problem Details Cause Setup and Maintenance Type Application Solution Check if the following are running Router AM Messageserver Restart the services and check if the time stamp appears Table 1 26 Information Command Center Reference No 14848627 Problem Details All services start except for Router Messageserver and AM Services although agentserver starts Refer the logs from FIC_ DB HOME log In RevAgent log the error explains that Id so 1 and librevlog so files not found The librevlog so file is present in Description FIC_DB_HOME lib where as there is no file called 1d so 1 Cause Required permissions on profile must be given with unix user Type Environment Solution The permission on profile file for the user is not given Giving permissions solves this issue Note From 7 3 3 Agent startup is decommissioned You must start the RAM servers individually Table 1 27 I
27. ted as 2002 in DWH Cause Database Configuration Type Usability Solution It depends on source date format If it contains the date field as 09 it converts it to 200 Table 1 16 Extract Transform Load Reference No 14777063 Problem Details Description How does KYC POT definitions work with OFSAAI Cause Ouery Type Ouery Solution The KYC F2T definitions works on OFSAAI platform in the following manner 1 F2T source must be defined with the source date format as mm dd y y yy 2 All the F2T definitions are defined using the data format as mm dd y y yy 3 During execution the date format of the definitions are compared with the date format mentioned in the database details screen 4 The NLS_DATE_FORMAT parameter values and the date format in the database details screen must be same as mm dd y y yy Troubleshooting of OFSAA Infrastructure 1 7 External Scheduler Interface Component 1 12 External Scheduler Interface Component Table 1 17 External Scheduler Interface Component Reference No 15935135 Problem Details Require steps to generate Run Execution ID which is used Description through External Scheduler Cause Query Type Operational Solution From OFSAAI 7 3 WSMRE Utility creates both Batch Group ID and Batch ID 1 13 Filters Table 1 18 Filters Reference No 14097329 Problem Details OFSAA interface pauses while editing two Tree Filters one a
28. ument Synatax Esic JXBG U P R lt Ext Unique ID gt G I D W BBatchNames Troubleshooting of OFSAA Infrastructure 1 9 Information Command Center Table 1 23 Information Command Center Reference No 14605056 Problem Details Description In case the batch fails which is the log file to refer Cause Query Type Query Solution Refer the following logs from the respective locations given Logs ICCServer Log FIC_APP_HOME icc logs FIC APP HOME icc bin Redirected Log Nohup Tomcat Log SCATALINA HOME logs Router AM Messageserver logs FIC_DB_HOME log FIC DB HOME bin Redirected Log Nohup T2T Logs FIC DB HOME log t2t Ftpshare lt INFODM gt logs lt source name gt lt MISDATE gt SOL Loader Logs E2T Logs FIC DB HOME log dmas Ftpshare lt INFODM gt logs lt source name gt lt MISDATE gt SOL Loader Logs Ftpshare STAGE lt SourceName gt MISDATE dat file location T2F Logs FIC DB HOME log extraction Ftpshare STAGE lt SourceName gt MISDATE Note In case your problem is not resolved it is recommended to contact Oracle Support with all the logs Table 1 24 Information Command Center Reference No 14621192 Problem Details Unable to execute batch an error message appears Description BATCH FAILED TO EXECUTE Cause Environment Type Application Error Solution Verify if back end servers ICCServer Router AM Messageserver are
29. use Entries must be wrong in DB_MASTER table Type Setup and Maintenance Troubleshooting of OFSAA Infrastructure 1 13 PR2 Table 1 35 Cont Metadata Browser Reference No 14737387 Problem Details Solution Verify the entries of INFODOM in DB_MASTER table and correct them 1 21 PR2 Table 1 36 PR2 Reference No 16041012 Problem Details Description Predecessor Task is missing while saving the existing process Cause JRE mis match in the client system Type Usability Solution Perform the following 1 Check the JRE version which is installed in the client system 2 Set the correct JRE version as explained in the Installation Manual 3 Set the correct Internet Explorer settings as explained in the Installation Manual 1 22 PR2 ICC Table 1 37 PR2 ICC Reference No 15829196 Problem Details After changing the OracleDB conf with parallel degree value to Description 6 the PR2 batch with parallel enabled decreases considerably Cause Database level setting needs to be done with respect to table sizing Type of Issue Performance Solution Check the table size 1 23 Security Management System Table 1 38 Security Management System Reference No 14609722 Problem Details The following error appears while trying to access User Activity Report gt Currently Logged in Users screen javax servlet ServletException Filter FilterServlet filter
30. ying to access OFSAA from Internet Explorer using IP address then this is the issue If it is launched from web browser using the hostname no error occurs while launching the migration rule DNS server must resolve IP hostname Verify your DNS server configuration 1 2 Application Table 1 2 Application Reference No 14686382 Problem Details Description FICServer error appears when trying to login Cause Browser Settings Type Login Solution Close the browser clear cache and then try to login with a new browser session If the issue persists contact Oracle Support Troubleshooting of OFSAA Infrastructure 1 1 Application Web Server 1 3 Application Web Server Table 1 3 Application Web Server Reference No 14675705 Problem Details Where to configure connection time out parameters in Description websphere Cause Connection time out is not set Type Connection Session Time Out Solution Modify the parameters with the following values com ibm websphere webservices http connectionTimeout 3600 Seconds timeout 3600 Seconds write_timeout 3600 Second 1 4 Archive Restore Table 1 4 Archive Restore Reference No 16082439 Problem Details Archive restore for ICC batch is not migrating parameters for Description DT Cause Restoring old DMP file Type Operational Solution Verify the time stamp of the archived DMP file Try to archive
Download Pdf Manuals
Related Search