ODS Initial Load can't be activated

[Former Member]

Hi,

i get an extract from the LO Cockpit ( 2LIS_13_VITM ) and transfer it 1:1 into an ODS. But the init Run never becomes Green in the ODS. Messages in the Monitor are

->Processing (data packet): Everything OK

->Subseq. processing (messages) : Missing messages

-->Act. of data records from ODS object ZSDVITM started

-->Missing message: Subseq. processing completed

->ODS act. (change-log) : Missing messages or warnings

-->for ZSDVITM : No Log Exists

The Request in the Reconstruction Tab always stays yellow

and never becomes green.

I'm tired of trying it. There are about 1300000 records

and it takes always 1hr to run throuh.

can someone help me please ?

regards

Ali

[Former Member]

Hi there and thanks for the fast replies,

i also tried to activate the request manually..

same result but the runtime error list shows following error :

DBIF_RSQL_SQL_ERROR

and the system log shows a detailed desc. of this error

Database error 1652 at FET access to table /BIC/AZSDV

> ORA-01652: unable to extend temp segment by 2560 in

> tablespace PSAPTEMP

it's the tablespace !!

where am i able to extend it ?

thanks in advance

Ali

[Former Member]

Hi Ali,

You would need to talk to your Basis resources to get the tablespaces extended (as suggested by Roberto earlier). Then your loads should be fine.

Cheers,

Sree

[Former Member]

Hi Ali,

Do you see any system dumps? Which release of BW are you working? Can you disable the flag for "automatic activation" in the ODS, and try loading first into the ODS as step 1.

Once the load is complete, can you try to manually activate the request in the ODS and let us know if it's successful or gives you any error messages.

Hope it helps,

Sree

[Former Member]

Hi Ali,

you have to check if there is some dump (ST22) or system log (SM21)..maybe you have to extend your tablespace...

Let us know..

Bye,

Roberto