on 09-22-2011 1:10 PM
Dear friends,
We have a problem in our test system.
One developer performed a transport which tried to change column from length 11 to 10 and after the transport, table is missing from database. We observed ABAP dumps DBIF_RSQL_SQL_ERROR with ORA-01438 which suggested us that there was some problem with field lenght change. After discussin, we have find out the culprate filed.
But, with me now problem is Partially active table which Does not exist in the database.
So now, what i should do to fix this problem.. Shuld i again increase filed length manually in test system and then try to perform SE14>Continue adjustment or what ?
In SE14 : Analyze Adjustment provide this information :
******************************************************************************************************************
Seq of steps
1 Initialization
2 Dropping of indexes, renaming of original table
3 No action
4 Activation of transparent table
5 Conversion of data to new table, deletion of renamed table
6 Creation of sec. indexes
Adjustment terminated in step 5
******************************************************************************************************************
******************************************************************************************************************
Initial table Table type Status
ZTAB1 Transparent Renamed
Renamed original table
QCMZTAB1 transparent Existent
Tgt.table
ZTAB1 Transparent Renamed
******************************************************************************************************************
thanks
ashish
Hello friends,
has someone found this problem earlier ??
I am not sure but it looks like we have "Type Conversion not Possible" as mentione below :
http://help.sap.com/saphelp_erp60_sp/helpdata/en/cf/21f1c5446011d189700000e8322d00/frameset.htm
waiting for some feedback..
thanks
ashish
Edited by: ashish vikas on Sep 22, 2011 4:15 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I had tried to reactivate table.. but it will not work as I had Terminated conversion : Adjustment terminated in step 5.
database object itself was not existent.. so consistency check is not helpful.
We recognized the problem.. at present, we have DDIC object for table with a field length 10(new lenght), a QCMtable which contains original data with filed lenght 11(Old value) and a conversion table QCM8table which has filed lenght 10(new value).
Now, in my case, original table had some Rows for that column lenght 11 and it was unable to transfer them to QCM8table.
I had raised an OSS to SAP.
thanks
ashish
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.