topic Re: Index Creation problem in Application Development and Automation Discussions

Index Creation problem

former_member925838 — Tue, 20 Nov 2012 10:53:39 GMT

Hello Experts,

I have created a index on MSEG as MSEG~ZP1. it is successfully created on development server.

but whenever i transfer request to quality server it throws error while importing request, and it gives warning that index does not exist in database system.

this happened twice.

what might be the problem??

Thanks,

Amar

Re: Index Creation problem

RaymondGiuseppi — Tue, 20 Nov 2012 10:59:21 GMT

You could

- activate index via SE14

- look carefully at the transport logs

Regards,

Raymond

Re: Index Creation problem

anup_deshmukh4 — Tue, 20 Nov 2012 10:59:27 GMT

Hello Amar,

Please Check the TCode SE14 ( DB Table adjustment ) for same There is an option to create a Index You will have to Go for it.

Hope this helps,

Anup

Re: Index Creation problem

former_member925838 — Tue, 20 Nov 2012 11:09:50 GMT

in transport logs it says, index might exist in database.

but it doesn't.

why do i need to create index by SE14 when i am transporting it from dev.

before this i have created many indexes, but never had to create index through SE14.

Re: Index Creation problem

RaymondGiuseppi — Tue, 20 Nov 2012 11:11:59 GMT

Did you check via DB02 for consistency between ddic and actual database ?

Re: Index Creation problem

ThomasZloch — Tue, 20 Nov 2012 11:21:59 GMT

Please provide more details, e.g. the exact warning and error message(s) from the transport log.

Next time please do so in your initial post.

Thomas

Re: Index Creation problem

former_member925838 — Tue, 20 Nov 2012 12:05:22 GMT

Thomas,

sorry for insufficient information.

i had checked consistency of database.

actually problem was with basis; because of insufficient table space on quality server it was throwing error.

thanks all for reply.