SUM error on phase: MAIN_SWITCH/PARMVNT_XCNV

[Former Member]

Hi,

Please assist us how to solve the error we encountered on SUM when upgrading to SP11 of Solution Manager.

Below is the error message shown:

       Checks after phase MAIN_SWITCH/PARMVNT_XCNV were negative!

Last error code set: Single errors (code &gt; 😎 found in logfile 'MVNTXCNV.ELG'<br/> 1 tp processes returned errors. View latest 'TP*.ECO' files in log-directory for details    

ERROR:
Detected the following errors:

# F:\usr\sap\SUM\abap\log\PD000514.DS3:
3 ETP000 NOT NULL DEFAULT ' ' ,
3 ETP000 [SOURCE_CLIENT] nvarchar(000003)
3 ETP000 NULL
3 ETP000
2WETP000 13:28:23: Retcode 1: error in DDL statement for "CTS_IMP_Q_STATE " - repeat
2EETP345 13:28:35: Retcode 1: SQL-error "2705-Column names in each table must be unique. Column nam
2EETP345 e 'TARGET_CLIENT' in table 'CTS_IMP_Q_STATE' is specified more than once." in DDL statemen
2EETP345 t for "CTS_IMP_Q_STATE "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 13:28:35: error in DDL, nametab for "CTS_IMP_Q_STATE" not activated

Attached is the log files.

Thank you!

Regards,

AJ

TP00.txt.zip

MVNTXCNV.txt.zip

PD000514.txt.zip

[Reagan]

Hello

2EETP345 13:28:35: Retcode 1: SQL-error "2705-Column names in each table must be unique. Column nam
2EETP345 e 'TARGET_CLIENT' in table 'CTS_IMP_Q_STATE' is specified more than once." in DDL statemen
2EETP345 t for "CTS_IMP_Q_STATE               "

Connect to the SAP system and perform a check on the table CTS_IMP_Q_STATE using Tx SE14.

Try "Activate and adjust the database" table with the "Save data" option.

Repeat the phase.

Regards

RB

[Former Member]

Hi RB,

We can't login to our GUI. The instance in SAPMMC is alredy in green but we still can't logon. How could we fix this? and the original instance was changed to instance 01 and 03.

Please see screenshot below:

Thank you!

Regards,

AJ

[Former Member]

Hi RB,

We also can't reset the update from SUM and we can't go back a step. It says that reset is not applicable on this phase. What should we do?

Thank you!

Regards,

AJ

[former_member185239]

Hi Almira,

You can't reset the upgrade in downtime phase.

Check the below telnet command

1. telnet 172.16.2.16 3201

2. telnet 172.16.2.16 3601

paste the dev_disp log file

Paste the output.

With Regards

Ashutosh

[Reagan]

What is the system number for the ABAP stack ?

I see you are trying to connect to the system with number 01 which appears to be a Java stack.

If you are unable to login to the system then provide the latest dev_w0 trace file from the work directory.

Regards

RB

[Former Member]

Hi RB,

What I did now is restore the whole SUM folder before then started SUM GUI again and I have already an option to step back one phase. But we came across an error again on -- phase REV_DTTRANS/STARTSAP_DTTRANS were negative!    

Please see screenshot on how we can resolve this asap.

Thank you!

Regards,

AJ

[Akashcm10]

This issue usually comes when you already applied changes for CTS_IMP_Q_STATE. now the upgrade is trying to add the same value. delete the old entry with the help of an abaper and then continue with the import.

best regards,

Krishna Prasad

[Former Member]

Hi Krishna,

Should I delete the old entry, thru SAP GUI? How would I do that if I can't start the instance after closing SUM and stopping the update? Should i reset the update from the beginning?

Thank you!

Regards,

AJ

[Akashcm10]

Do it from SAP GUI with the help of an abaper. you think in this way.

1. before upgrading, may you have applied note corrections and it has created one entry. now upgrade is trying to create the same entry which is leading to error.

I hope this helps.

Besat regards,

Krishna Prasad

[Former Member]

Hi Krishna,

We have started the instance in SAPMMC but it is now with a different instance. it became 01 and 03. I think it is the shadow instance? But I can't logon. Please see screenshot below:

Thank you!

Regards,

AJ

[former_member185239]

Hi Almira,

You need to perform the below steps

1. Check the table CTS_IMP_Q_STATE , whether it is activated or not.

2. If it is activated , then try to upgrade the R3tarns and tp to latest level

3. If the second point does not work then , check the duplicate entries in the table CTS_IMP_Q_STATE.

    Remove the entries and retry the steps.

You can also retry the steps after removing the entry CTS_IMP_Q_STATE from DDXTT table.

But i have no idea , about the table CTS_IMP_Q_STATE

Though it is temporary storage table and delivered empty by SAP.

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi Ashutosh,

I have checked the table in SQL but I can't check it on SAP GUI since it can't be started even if I stopped the update of SUM. I can't logon.

Please see screenshot for the SL query that was run to check the table.

Regards,

AJ

[former_member185239]

Hi Almira,

Try to logon to client 000 with DDIC user

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi Ashutosh,

We can't login to SAP GUI. We can't start the instance itself in SAPMMC after we stop the update of SUM and close the window.

Please see screenshot.

Regards,

AJ