Informatica Error 36331
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX Inside-ERP VoIP_News Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Ramnath.Awate JoeTorre Andrew.S.Baker bracke Locutus Dennis Stevenson Craig Borysowich Richard DukeGanote mircea_luca iudithm Clinton Jones Nikki Klein AbhaiTripathi Iqbalyk bluesguyAZ59 blrvenkat jakarman COMPANIES GeoTrust Juniper Networks HP, Voltage Security and ... Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Siebel Groups Ask a New Question Siebel Analytics For discussion on Siebel Analytics , please visit the Oracle BI group. More Siebel Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. ETL execution with DAC fails with error code 36331 Rishu Saxena asked Oct 29, 2009 | Replies (13) Hi Gurus, I have installed OBIEE environment, have created databases, database connections, configurations as per the OBIEE installation and configuration setting. All is working fine as per the document. I am trying to run an existing execution plan 'CRM Complete Service - Siebel 8.1'. and first step for change capture for Siebel OLTP is successfully completed. After that, several tasks fail with a common error: 36331. Excerpt from log file is as follows: 11 SEVERE Tue Oct 27 16:53:16 EAT 2009 Join this group Popular White Paper On This Topic The Death of Traditional Data Integration: How the Changing Nature of IT Mandates New Approaches and Technologies 13Replies
WizardInformatica Cloud for Amazon AWSComplex Event ProcessingProactive Healthcare Decision ManagementProactive MonitoringReal-Time Alert ManagerRule PointData IntegrationB2B Data ExchangeB2B Data TransformationData Integration HubData ReplicationData ServicesData Validation OptionFast CloneInformatica PlatformMetadata ManagerPowerCenterPowerCenter ExpressPowerExchangePowerExchange AdaptersData QualityAddress DoctorAddress Doctor CloudData as a ServiceData ExplorerData QualityData Quality Services (Strike Iron)Data Security Group (Formerly ILM)Data ArchiveData Centric SecuritySecure@SourceSecure TestingMaster Data ManagementIdentity ResolutionMDM Big Data Relationship ManagementMDM Multidomain EditionMDM Registry EditionProcess AutomationActiveVOSCloud ExtendProduct Information ManagementInformatica ProcurementProduct Information ManagementUltra MessagingUltra http://siebel.ittoolbox.com/groups/technical-functional/siebel-analytics-l/etl-execution-with-dac-fails-with-error-code-36331-3084988 Messaging OptionsUltra Messaging Persistence EditionUltra Messaging Queuing EditionUltra Messaging Streaming EditionVibe Data StreamDocumentationKnowledge BaseResourcesPAM (Product Availability Matrices)Support TVInformatica Expert AssistantVelocity (Best Practices)Mapping TemplatesDebugging ToolsUser Groupsglobal.search.communityLog inSign Up Informatica Network > Data Integration > PowerCenter > Discussions Please enter a title. You cannot post a blank https://network.informatica.com/thread/52081 message. Please enter your message and try again. 13 Replies Latest reply: Sep 25, 2016 10:05 PM by Tarang Jain WorkFlowMessage : Error Message : Unknown reason for error code 36331 Carlos Díaz May 8, 2015 1:02 PM This error happend randomly un different tasks. I can restarted and finish fine.So I am assuming this may be related to performance or number of database connections? or probably deadlock?My question for the forum is what kind of situations can raise this error.Thanks in advise.c. ANOMALY INFO::: Error while executing : INFORMATICA TASK:CUSTOM_SDE:wf_SDE_ProjectDimension:1:(Source : FULL Target : INCREMENTAL) MESSAGE:::java.lang.Exception: pmcmd startworkflow -sv II_SOP_OBI_PRD -d Domain_SOP_OBI_PRD -u Administrator -p **** -f CUSTOM_SDE -paramfile E:\Informatica\PowerCenter9.5.1\server\infa_shared\SrcFiles\CUSTOM_SDE.wf_SDE_ProjectDimension.SEBL_78.txt wf_SDE_ProjectDimension Status Desc : Failed WorkFlowMessage : Error Message : Unknown reason for error code 36331 ErrorCode : 36331 EXCEPTION CLASS::: java.lang.Exception com.siebel.analytics.etl.etltask.GenericTa
Slideshow Wallpaper Ad Full Width Page Archives Page Homepage Blog No Leaderboard Typography Business Entertainment Blogs http://mkashu.blogspot.com/2013/08/dac-error-code-36331.html Columnists Max Mag Staff Sports Blogs Columnists Fashion Tech Travel https://biproducts.wordpress.com/2013/03/12/informatica-workflow-error/ Food All About Data Warehousing and Business Intelligence Support Center Don't miss OBIA 7.9.6.3 InstallationPosted 125 days ago What is OBIEE?Posted 1 days ago OBIEE 11G ArchitecturePosted 10 days ago Why Data warehousePosted 13 days ago Tuesday, 20 August 2013 informatica error dac error code 36331 By Kashif M on 08:33:00 I have recently faced this error in OBIA 7.9.6.3 To retify it, 1. You need to set Oracle Database Parameter "Processes" from 150 to 500, It will be in the location ---- E:\app\7stl\admin\apps\pfile 2. Go todatawarehouse tableW_ORA_GL_JOURNALS_F_TMP and find the columnGL_JE_BATCHES_NAME, informatica error 36331 change the size from 100 to 200. 3. Go to datawarehouse table W_GL_SEGMENT_DSand find the columnSEGMENT_VAL_CODE,change the size from 50to 100. 4. more important thing is just check all the connection once again, odbc connection,informatica relational connection and finally dac paramenter generation. error 36331 mainly happens in informatica because of values extended limit from source to target, that is our OLTP to OLAP. Sample error log for this DIRECTOR> VAR_27028 Use override value [DataWarehouse] for session parameter:[$DBConnection_OLAP]. DIRECTOR> VAR_27028 Use override value [ORA_R1213] for session parameter:[$DBConnection_OLTP]. DIRECTOR> VAR_27028 Use override value [ORA_R1213.DATAWAREHOUSE.SDE_ORAR1213_Adaptor.SDE_ORA_GLJournals_Full.log] for session parameter:[$PMSessionLogFile]. DIRECTOR> VAR_27028 Use override value [1000] for mapping parameter:[$$DATASOURCE_NUM_ID]. DIRECTOR> VAR_27028 Use override value ['Y'] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$FILTER_BY_LEDGER_ID]. DIRECTOR> VAR_27028 Use override value ['Y'] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$FILTER_BY_LEDGER_TYPE]. DIRECTOR> VAR_27028 Use override value [01/01/2001] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$INITIAL_EXTRACT_DATE]. DIRECTOR> VAR_27028 Use override value [] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$LAST_EXTRACT_DATE]. DIRECTOR> VAR_27028 Use override value [2021] for mapping parameter:[mplt_BC_ORA_GLXactsJournalsExtract.$$LEDGE
Error Posted on March 12, 2013 by raghunagadasari Hi Experts, We are working on OBIApps 7963 and we are completely new to Informatica. While running the Execution Plans through DAC we are getting the below errors. For Example, we can take the detail level information of SDE_ORA_ExchangeRateGeneral task. And the Status Description is below. ------------------------------------------------- 2013-03-12 02:13:45.519 INFORMATICA TASK:SDE_ORAR1213_Adaptor:SDE_ORA_ExchangeRateGeneral_Full:(Source : FULL Target : FULL) has started. ANOMALY INFO::: Error while executing : INFORMATICA TASK:SDE_ORAR1213_Adaptor:SDE_ORA_ExchangeRateGeneral_Full:(Source : FULL Target : FULL) MESSAGE::: Irrecoverable Error Error while contacting Informatica server for getting workflow status for SDE_ORA_ExchangeRateGeneral_Full Error Code = 36331:Unknown reason for error code 36331 Pmcmd output : ===================================== STD OUTPUT ===================================== Informatica(r) PMCMD, version [9.0.1 HotFix2], build [242.1111], LINUX 32-bit Copyright (c) Informatica Corporation 1994 - 2010 All Rights Reserved. Invoked at Tue Mar 12 02:14:06 2013 Connected to Integration Service: [EISBI_IS]. Integration Service status: [Running] Integration Service startup time: [Tue Jan 29 22:41:20 2013] Integration Service current time: [Tue Mar 12 02:14:06 2013] Folder: [SDE_ORAR1213_Adaptor] Workflow: [SDE_ORA_ExchangeRateGeneral_Full] version [5]. Workflow run status: [Failed] Workflow run error code: [36331] Workflow run error message: [WARNING: Session task instance [SDE_ORA_ExchangeRateGeneral_Compress_Full] failed and its "fail parent if this task fails" setting is turned on. So, Workflow [SDE_ORA_ExchangeRateGeneral_Full] will be failed.] Workflow run id [11333]. Start time: [Tue Mar 12 02:13:46 2013] End time: [Tue Mar 12 02:13:47 2013] Workflow log file: [/d02/informatica/server/infa_shared/WorkflowLogs/SDE_ORA_ExchangeRateGeneral_Full.log] Workflow run typ