This discussion is archived
12 Replies Latest reply: May 8, 2013 2:24 AM by naeem akhtar RSS

ETL error on SDE_ORA_EAMCostFact

naeem akhtar Newbie
Currently Being Moderated
Hi,

I am getting an error in SDE_ORA_EAMCostFact task.

Following is the session log.

http://pastebin.com/YeeCix2b

Can someone help me in this matter?

Thanks
Naeem Akhtar
  • 1. Re: ETL error on SDE_ORA_EAMCostFact
    Srini VEERAVALLI Guru
    Currently Being Moderated
    Looks like its showing database error check it once. How about other tasks during concurrent execution?
  • 2. Re: ETL error on SDE_ORA_EAMCostFact
    naeem akhtar Newbie
    Currently Being Moderated
    How to resolve this database error?

    Other tasks are completed successfully.

    Thanks
    Naeem Akhtar
  • 3. Re: ETL error on SDE_ORA_EAMCostFact
    OBD Newbie
    Currently Being Moderated
    Hi,

    We have recently encountered this error related, its purely related to rollback segment and its related to DB. Your DBA has to increase UNDO segment according to data in DB.

    Also it might require to analyse DB alert log to solve this at DB end.

    Mark helpful...
  • 4. Re: ETL error on SDE_ORA_EAMCostFact
    naeem akhtar Newbie
    Currently Being Moderated
    Hi,

    Thanks for your message.

    on which DB we need to change the parameters? OLTP or Datawarehouse?

    Does this only relate to undo space or could be some other issue as well?

    Thanks
    Naeem Akhtar
  • 5. Re: ETL error on SDE_ORA_EAMCostFact
    naeem akhtar Newbie
    Currently Being Moderated
    Hi srini,

    I am still facing this error,

    Could you please tell me in bit detail which steps need to take for the resolution?

    Thanks
    Naeem Akhtar
  • 6. Re: ETL error on SDE_ORA_EAMCostFact
    SunilSharma Expert
    Currently Being Moderated
    can you paste the error here. i m not able to access the link its blocked
  • 7. Re: ETL error on SDE_ORA_EAMCostFact
    naeem akhtar Newbie
    Currently Being Moderated
    Follwing Debug in log

    2013-03-29 18:05:49 : DEBUG : (7556 | MAPPING) : (IS | BIA_IS) : node01_BIAPPS : TE_7004 : Transformation Parse Warning ['WIP_JOB_STATUS~'||INP_STATUS_TYPE]; transformation continues...
    2013-03-29 18:05:49 : DEBUG : (7556 | MAPPING) : (IS | BIA_IS) : node01_BIAPPS : TE_7004 : Transformation Parse Warning [<<PM Parse Warning>> [INP_STATUS_TYPE]: operand converted to a string
    ... 'WIP_JOB_STATUS~'||>>>>INP_STATUS_TYPE<<<<]; transformation continues...
    2013-03-29 18:05:49 : DEBUG : (7556 | MAPPING) : (IS | BIA_IS) : node01_BIAPPS : TE_7004 : Transformation Parse Warning ['STORAGE_LOC~'||INP_CURRENT_ORGANIZATION_ID||'~'||INP_CURRENT_SUBINVENTORY_CODE||'~'||INP_CURRENT_LOCATOR_ID]; transformation continues...
    2013-03-29 18:05:49 : DEBUG : (7556 | MAPPING) : (IS | BIA_IS) : node01_BIAPPS : TE_7004 : Transformation Parse Warning [<<PM Parse Warning>> [||]: operand converted to a string

    and following errors.

    2013-03-29 18:05:53 : ERROR : (7556 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TE_7007 : Transformation Evaluation Error [<<Expression Error>> [TO_DATE]: invalid string for converting to Date
    ... t:TO_DATE(s:'JULY-12',s:'MON-RR')]
    2013-03-29 18:05:53 : ERROR : (7556 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TT_11132 : Transformation [mplt_SA_ORA_EAMCostFact.Exp_W_EAM_COST_FACT_F] had an error evaluating output column [EXT_EXCHANGE_DT]. Error message is [<<Expression Error>> [TO_DATE]: invalid string for converting to Date
    ... t:TO_DATE(s:'JULY-12',s:'MON-RR')].

    2013-03-29 18:05:53 : ERROR : (7556 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TT_11019 : There is an error in the port [EXT_EXCHANGE_DT]: The default value for the port is set to: ERROR(<<Expression Error>> [ERROR]: transformation error
    ... nl:ERROR(s:'transformation error')).
    2013-03-29 18:05:53 : ERROR : (7556 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : TT_11021 : An error occurred moving data from the transformation mplt_SA_ORA_EAMCostFact.Exp_W_EAM_COST_FACT_F: to the transformation W_EAM_COST_FS.
    2013-03-29 18:05:53 : ERROR : (7556 | TRANSF_1_1_1) : (IS | BIA_IS) : node01_BIAPPS : CMN_1086 : mplt_SA_ORA_EAMCostFact.Exp_W_EAM_COST_FACT_F: Number of errors exceeded threshold [1].


    Thanks for your message.

    Please let me know if you need more inoformation.

    Naeem Akhtar
  • 8. Re: ETL error on SDE_ORA_EAMCostFact
    SunilSharma Expert
    Currently Being Moderated
    transformation errors should not be a problem there is something else because of which its failing. can you paste the complete log here
  • 9. Re: ETL error on SDE_ORA_EAMCostFact
    Sher Ullah Baig Explorer
    Currently Being Moderated
    Hi
    have you tried what 'ODB' was saying. +"DBA has to increase UNDO segment according to data in DB"+

    regards
    sher
  • 10. Re: ETL error on SDE_ORA_EAMCostFact
    naeem akhtar Newbie
    Currently Being Moderated
    Hi,

    Complete log is not fitting into message here, Can you tell you your email address so that I can forward?

    Regards
    Naeem Akhtar
  • 11. Re: ETL error on SDE_ORA_EAMCostFact
    naeem akhtar Newbie
    Currently Being Moderated
    Hi,

    Thanks for your message.

    I have increased the undo on datawarehouse db. Do I need to do the same on EBS DB? (Source)?

    Naeem
  • 12. Re: ETL error on SDE_ORA_EAMCostFact
    naeem akhtar Newbie
    Currently Being Moderated
    Identified that this error was due to source.

    Thanks everyone for help.

    Naeeem

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points