We are working on the upgrade from ECC6.0 to ECC6.0 with EHP4 and now running in the downtime phase. In the downtime phase, the upgrade stopped in the phase of MAIN_SWITCH/PARMVNT_XCNV and stated that to check the logs of MVNTXCNV.ELG. In the log file it stated that
MVNTTABS ERRORS:ddlntabs and RETURN CODE in PD000825.FSO
SQL -error Duplicate name:SRT_MONLoG_DATA2 in DDL st
error in DDL nametab for "SRT_MONLOG_DATA2 not activated
Then I have searched in SMP and in SDN and came to know that we need to implement the notes of
Note 1399438 - System upgrade stops in phase XCNV
Note 1310677 - System upgrade terminates in phase MAIN_SWITCH/PARMVNT_XCN
Hence, I have started the instance manually and unlocked the tp to login as different user for applying this note ( Because we cannot apply note usign DDIC ) . Then able to login into the system and downloaded the notes as well,
While implementing the when I try to create a request - it immediately throwing a short dump and dump states that
SQL error in the database when accessing a table
Database error text: POS(40) too few values
Internal call code: RSQL/INSR/EO70C
Please check the same in SM21
In system logs the logs says that
Runtime error DBIF_RSQL_SQL_ERROR
Short dump created
Database error -1200 at PRE access to table E070c
POS (40) Too few values
Instead of creating a new request and tried to use own request but the results are same, Also i tried to change the client settings from automatic recording of changes and also changes w/o automatic recording of changes - but both are giving the same output.
Is there any other possibility to get rid off this issue? Any suggestions are highly appreciated
Its fixed and I have just implemented the note 589296 - Solved our issue
select * from "SAPFSO"."DDXTT~" where TABNAME = 'SRT_MONLOG_DATA2'
select * from "SAPFSO"."DDXTT" where TABNAME = 'SRT_MONLOG_DATA2'
Check it approximately it should return with the FLAG value as F
update "SAPFSO"."DDXTT~" set modeflag = 'A' where TABNAME = 'SRT_MONLOG_DATA2'
Thanks for your support