here i am using the following query to extract the data from oracle9i database through Oracle Enterprise stage
##W TCOS 000049 23:26:35(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
##W TDOR 000062 23:26:39(001) <Oracle_Enterprise_12> Column HOURS floating point decimal is not fully supported; adjusting the scale.
##W TFIP 000022 23:26:39(005) <Oracle_Enterprise_12> When checking operator: When binding output interface field "Contractor_ID" to field "Contractor_ID": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
##W TFIP 000022 23:26:39(006) <Oracle_Enterprise_12> When checking operator: When binding output interface field "PONUM" to field "PONUM": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
##W TFOP 000062 23:28:50(000) <Oracle_Enterprise_12,0> Column HOURS floating point decimal is not fully supported; adjusting the scale.
>##E TFOP 000212 23:28:50(001) <Oracle_Enterprise_12,0> Oracle call failed; sqlcode = -1652; message: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01>.
>##E TFOP 000176 23:28:50(002) <Oracle_Enterprise_12,0> Array Fetch failed for: SELECT
>TS.PRID,
>TS.PRISADJUSTMENT,
>SP.NAME,
>NVL(X.XDM_CONTR_ID,SR.UNIQUE_NAME) Contractor_ID,
>SR.FULL_NAME,
>'PO'||NVL(X.XDM_CONTR_ID,SR.UNIQUE_NAME) PONUM,
>SUM(TE.PRACTSUM/60/60) hours,
>TP.PRSTART,
>TP.PRFINISH
>FROM
>PRTIMEENTRY TE,
>PRTIMESHEET TS,
>PRTIMEPERIOD TP,
>SRM_RESOURCES SR,
>XDM_CDF_SRM_RESOURCES X,
>PRASSIGNMENT PA,
>PRTASK PT,
>PRJ_PROJECTS PP,
>SRM_PROJECTS SP
>WHERE
>TE.PRASSIGNMENTID = PA.PRID AND
>TE.PRTIMESHEETID = TS.PRID AND
>TS.PRRESOURCEID = SR.ID AND
>SR.ID = X.PARENT_ID (+) AND
>PA.PRTASKID = PT.PRID AND
>PT.PRPROJECTID = PP.PRID AND
>PP.PRID = SP.ID AND
>SR.PERSON_TYPE = 301 AND
>TS.PRSTATUS = 4
>GROUP BY
>TS.PRID,
>TS.PRISADJUSTMENT,
>NVL(X.XDM_CONTR_ID,SR.UNIQUE_NAME),
>SR.FULL_NAME,
>'PO'|| NVL(X.XDM_CONTR_ID,SR.UNIQUE_NAME),
>SP.NAME,
>TP.PRSTART,
>TP.PRFINISH.
>##E TFOP 000089 23:28:50(003) <Oracle_Enterprise_12,0> The runLocally() of the operator failed.
##I TFOP 000094 23:28:50(004) <Oracle_Enterprise_12,0> Output 0 produced 0 records.
>##E TFPM 000040 23:28:50(005) <Oracle_Enterprise_12,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
>##E TFPM 000338 23:28:51(000) <main_program> Unexpected exit status 1
>##E TFSR 000011 23:28:56(000) <main_program> Step execution finished with status = FAILED.
##I TCOS 000026 23:28:56(001) <main_program> Startup time, 0:11; production run time, 2:11.
what exactly the problem and where i need to fix it.... i mean, is it problem with database or do i need to take care anything in oracle enterprise stage ?
Thanks in advance
pongal
error while extracting the data from oracle enterprise stage
Moderators: chulett, rschirm, roy
Pongal,
you need to talk with your DBA about this, as the message states the process cannot allocated Oracle EXTENTS.
you need to talk with your DBA about this, as the message states the process cannot allocated Oracle EXTENTS.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
main thing you need to do is use datastage as it is meant. Why are you writing these complex queries in one stage.
Performance of your full job will be a lot better if you use one oracle-stage per table which you then join in datastage and also use the ds-aggregator.
This will also get you a better load balance between your DS and DB-server.
Performance of your full job will be a lot better if you use one oracle-stage per table which you then join in datastage and also use the ds-aggregator.
This will also get you a better load balance between your DS and DB-server.