Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERROR ODI-1134 Agent encountered an error: ODI-1217: Session Load TRG_CITY_Physical_SESS (58) fails

user649990Feb 2 2015 — edited Feb 2 2015

Hi

I am new to ODI

I am getting following error . Can someone help me in this

Below is the issue

2015-02-02 06:42:06.528 NOTIFICATION Start generation of map physical design: MapPhysicalDesign Load TRG_CITY.Physical

2015-02-02 06:42:10.256 NOTIFICATION Finished generation of map physical design: MapPhysicalDesign Load TRG_CITY.Physical

2015-02-02 06:42:10.620 NOTIFICATION New data source: [ODI_DEMO/*******@jdbc:oracle:thin:@localhost:1521:xe]

2015-02-02 06:42:10.849 NOTIFICATION New data source: [ODI_demo/*******@jdbc:oracle:thin:@localhost:1521:xe]

2015-02-02 06:42:11.191 WARNING SQLCommand execution failure: ORA-00942: table or view does not exist

Failed query text:

insert into ODI_STAGING.E$_TRG_CITY

(

    ODI_PK,

    ODI_SESS_NO,

    ODI_ROW_ID,

    ODI_ERR_TYPE,

    ODI_ERR_MESS,

    ODI_CHECK_DATE,

    ODI_ORIGIN,

    ODI_CONS_NAME,

    ODI_CONS_TYPE,

    CITY_ID,

    REGION_ID,

    CITY,

    POPULATION

)

select

    SYS_GUID(),

    '0344ccfc-8c33-4455-b5f3-3c297567597b',

    rowid,

    'F',

    'ODI-15066: The column CITY_ID cannot be null.',

    sysdate,

    '(5)Demo.Load TRG_CITY',

    'CITY_ID',

    'NN',   

    CITY_ID,

    REGION_ID,

    CITY,

    POPULATION

from    ODI_STAGING.I$_TRG_CITY

where    CITY_ID is null

2015-02-02 06:42:11.365 WARNING ODI-1134 Agent Internal encountered an error: ODI-1226: Step Physical_STEP fails after 1 attempt(s).

2015-02-02 06:42:11.366 ERROR ODI-1217 Session Load TRG_CITY_Physical_SESS (58) fails with return code ODI-1298.

2015-02-02 06:42:11.397 ERROR ODI-1134 Agent  encountered an error: ODI-1217: Session Load TRG_CITY_Physical_SESS (58) fails with return code ODI-1298. Caused by: ODI-1226: Step Physical_STEP fails after 1 attempt(s).

sementic update edge for SRC_CITY : SRC_CITY->FILTER

sementic update edge for TRG_CITY : FILTER->TRG_CITY

sementic update edge for FILTER : FILTER->TRG_CITY

sementic update edge for FILTER : SRC_CITY->FILTER

sementic update edge for SRC_CITY : SRC_CITY->FILTER

sementic update edge for TRG_CITY : FILTER->TRG_CITY

sementic update edge for FILTER : FILTER->TRG_CITY

sementic update edge for FILTER : SRC_CITY->FILTER

2015-02-02 06:44:13.586 NOTIFICATION New data source: [ODI_demo/*******@jdbc:oracle:thin:@localhost:1521:xe]

2015-02-02 06:44:19.908 NOTIFICATION New data source: [ODI_demo/*******@jdbc:oracle:thin:@localhost:1521:xe]

2015-02-02 06:49:15.955 NOTIFICATION New data source: [ODI_DEMO/*******@jdbc:oracle:thin:@localhost:1521:xe]

edge added FILTER->FILTER_AP

sementic update edge for FILTER : SRC_CITY->FILTER

sementic update edge for SRC_CITY : SRC_CITY->FILTER

sementic update edge for FILTER_AP : FILTER_AP->TRG_CITY

sementic update edge for FILTER_AP : FILTER->FILTER_AP

sementic update edge for TRG_CITY : FILTER_AP->TRG_CITY

edge added FILTER->FILTER_AP

sementic update edge for FILTER : SRC_CITY->FILTER

sementic update edge for SRC_CITY : SRC_CITY->FILTER

sementic update edge for FILTER_AP : FILTER_AP->TRG_CITY

sementic update edge for FILTER_AP : FILTER->FILTER_AP

sementic update edge for TRG_CITY : FILTER_AP->TRG_CITY

edge added FILTER->FILTER_AP

sementic update edge for FILTER : SRC_CITY->FILTER

sementic update edge for SRC_CITY : SRC_CITY->FILTER

sementic update edge for FILTER_AP : FILTER_AP->TRG_CITY

sementic update edge for FILTER_AP : FILTER->FILTER_AP

sementic update edge for TRG_CITY : FILTER_AP->TRG_CITY

edge added FILTER->FILTER_AP

sementic update edge for FILTER : SRC_CITY->FILTER

sementic update edge for SRC_CITY : SRC_CITY->FILTER

sementic update edge for FILTER_AP : FILTER_AP->TRG_CITY

sementic update edge for FILTER_AP : FILTER->FILTER_AP

sementic update edge for TRG_CITY : FILTER_AP->TRG_CITY

edge added FILTER->FILTER_AP

sementic update edge for FILTER : SRC_CITY->FILTER

sementic update edge for SRC_CITY : SRC_CITY->FILTER

sementic update edge for FILTER_AP : FILTER_AP->TRG_CITY

sementic update edge for FILTER_AP : FILTER->FILTER_AP

sementic update edge for TRG_CITY : FILTER_AP->TRG_CITY

sementic update edge for FILTER_AP : FILTER_AP->TRG_CITY

sementic update edge for FILTER_AP : FILTER->FILTER_AP

2015-02-02 06:56:14.901 WARNING Removing unused MapReference object: MapReference=>IKnowledgeModule (FCO: ) LKM SQL to SQL (Built-In)[102] owner=Mapping Load TRG_CITY[5] owning folder=DEMO.Sales Administration

2015-02-02 06:56:17.481 NOTIFICATION Start generation of map physical design: MapPhysicalDesign Load TRG_CITY.Physical

2015-02-02 06:56:21.045 NOTIFICATION Finished generation of map physical design: MapPhysicalDesign Load TRG_CITY.Physical

2015-02-02 06:56:21.287 NOTIFICATION New data source: [ODI_DEMO/*******@jdbc:oracle:thin:@localhost:1521:xe]

2015-02-02 06:56:21.527 WARNING SQLCommand execution failure: ORA-00942: table or view does not exist

Failed query text:

insert into ODI_STAGING.E$_TRG_CITY

(

    ODI_PK,

    ODI_SESS_NO,

    ODI_ROW_ID,

    ODI_ERR_TYPE,

    ODI_ERR_MESS,

    ODI_CHECK_DATE,

    ODI_ORIGIN,

    ODI_CONS_NAME,

    ODI_CONS_TYPE,

    CITY_ID,

    REGION_ID,

    CITY,

    POPULATION

)

select

    SYS_GUID(),

    '4dd78c38-6c75-443a-acd3-12757c264be6',

    rowid,

    'F',

    'ODI-15066: The column CITY_ID cannot be null.',

    sysdate,

    '(5)Demo.Load TRG_CITY',

    'CITY_ID',

    'NN',   

    CITY_ID,

    REGION_ID,

    CITY,

    POPULATION

from    ODI_STAGING.I$_TRG_CITY

where    CITY_ID is null

2015-02-02 06:56:21.557 WARNING ODI-1134 Agent Internal encountered an error: ODI-1226: Step Physical_STEP fails after 1 attempt(s).

2015-02-02 06:56:21.558 ERROR ODI-1217 Session Load TRG_CITY_Physical_SESS (59) fails with return code ODI-1298.

2015-02-02 06:56:21.572 ERROR ODI-1134 Agent  encountered an error: ODI-1217: Session Load TRG_CITY_Physical_SESS (59) fails with return code ODI-1298. Caused by: ODI-1226: Step Physical_STEP fails after 1 attempt(s).

edge added FILTER->FILTER_AP

sementic update edge for FILTER : SRC_CITY->FILTER

sementic update edge for SRC_CITY : SRC_CITY->FILTER

sementic update edge for FILTER_AP : FILTER_AP->TRG_CITY

sementic update edge for FILTER_AP : FILTER->FILTER_AP

sementic update edge for TRG_CITY : FILTER_AP->TRG_CITY

sementic update edge for FILTER_AP : FILTER_AP->TRG_CITY

sementic update edge for FILTER_AP : FILTER->FILTER_AP

sementic update edge for FILTER_AP : FILTER_AP->TRG_CITY

sementic update edge for FILTER_AP : FILTER->FILTER_AP

2015-02-02 06:57:55.238 WARNING Removing unused MapReference object: MapReference=>IKnowledgeModule (FCO: ) LKM Oracle to Oracle Pull (DB Link)[205] owner=Mapping Load TRG_CITY[5] owning folder=DEMO.Sales Administration

2015-02-02 06:57:55.239 WARNING Removing unused MapReference object: MapReference=>IKnowledgeModule (FCO: ) LKM SQL to SQL (Built-In)[null] owner=Mapping Load TRG_CITY[5] owning folder=DEMO.Sales Administration

2015-02-02 06:58:00.372 NOTIFICATION Start generation of map physical design: MapPhysicalDesign Load TRG_CITY.Physical

2015-02-02 06:58:03.426 NOTIFICATION Finished generation of map physical design: MapPhysicalDesign Load TRG_CITY.Physical

2015-02-02 06:58:03.700 NOTIFICATION New data source: [ODI_demo/*******@jdbc:oracle:thin:@localhost:1521:xe]

2015-02-02 06:58:03.719 WARNING SQLCommand execution failure: ORA-02024: database link not found

Failed query text:

drop database link TRG_ODIDEMO

      

2015-02-02 06:58:03.789 NOTIFICATION New data source: [ODI_DEMO/*******@jdbc:oracle:thin:@localhost:1521:xe]

2015-02-02 06:58:04.019 WARNING SQLCommand execution failure: ORA-00942: table or view does not exist

Failed query text:

insert into ODI_STAGING.E$_TRG_CITY

(

    ODI_PK,

    ODI_SESS_NO,

    ODI_ROW_ID,

    ODI_ERR_TYPE,

    ODI_ERR_MESS,

    ODI_CHECK_DATE,

    ODI_ORIGIN,

    ODI_CONS_NAME,

    ODI_CONS_TYPE,

    CITY_ID,

    REGION_ID,

    CITY,

    POPULATION

)

select

    SYS_GUID(),

    'bfa3f354-881f-4139-95a1-5565cc33dcc9',

    rowid,

    'F',

    'ODI-15066: The column CITY_ID cannot be null.',

    sysdate,

    '(5)Demo.Load TRG_CITY',

    'CITY_ID',

    'NN',   

    CITY_ID,

    REGION_ID,

    CITY,

    POPULATION

from    ODI_STAGING.I$_TRG_CITY

where    CITY_ID is null

2015-02-02 06:58:04.052 WARNING ODI-1134 Agent Internal encountered an error: ODI-1226: Step Physical_STEP fails after 1 attempt(s).

2015-02-02 06:58:04.052 ERROR ODI-1217 Session Load TRG_CITY_Physical_SESS (60) fails with return code ODI-1298.

2015-02-02 06:58:04.064 ERROR ODI-1134 Agent  encountered an error: ODI-1217: Session Load TRG_CITY_Physical_SESS (60) fails with return code ODI-1298. Caused by: ODI-1226: Step Physical_STEP fails after 1 attempt(s).

edge added FILTER->FILTER_AP

sementic update edge for FILTER : SRC_CITY->FILTER

sementic update edge for SRC_CITY : SRC_CITY->FILTER

sementic update edge for FILTER_AP : FILTER_AP->TRG_CITY

sementic update edge for FILTER_AP : FILTER->FILTER_AP

sementic update edge for TRG_CITY : FILTER_AP->TRG_CITY
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2015
Added on Feb 2 2015
#business-intelligence-applications, #data-integrator, #system-management-and-integration
1 comment
1,564 views