Current Phase: MAIN_NEWBAS/PARCONV_UPG_DS. I am stucks

[Former Member]

Hi Gurus.

I am facing a issue during the update to SP14 on Sap Solution Manager 7.1. Currently I am on the  Phase: MAIN_NEWBAS/PARCONV_UPG_DS and I am stopped in this phase.

The  message  SUM showed is:

Checks after phase MAIN_NEWBAS/PARCONV_UPG_DS were negative!

Last error code set: Unhandled mode flags found, check 'PARCONV.LOG' for details

Trouble Ticket Generation

A trouble ticket and an archive with all relevant log files have been generated.

Trouble ticket: "Z:\SUM\abap\log\SAPup_troubleticket.log"

Log archive: "Z:\SUM\abap\log\SAPup_troubleticket_logs.sar"

Repeat phase MAIN_NEWBAS/PARCONV_UPG_DS to continue at the point it stopped

Initialize phase MAIN_NEWBAS/PARCONV_UPG_DS to restart it from the beginning

INIT

I  selected the INIT check, but the error back.

I searched in the log 'PARCONV.LOG' and I found the information forward:

2 ETQ399 CONV ENTRY TBATG TABLESR_SCHDL                        0CNVI 20160826DDIC       

2 ETQ399 CONV ENTRY TBATG TABLLOYD_MSH_MSQTIER                 0CNVI 20160826DDIC       

2 ETQ399 CONV ENTRY TBATG TABLLOYD_PPA                         0CNVI 20160826DDIC       

2 ETQ399 CONV ENTRY TBATG TABLLOYD_PT_ACCT                     0CNVI 20160826DDIC       

2 ETQ399 CONV ENTRY TBATG TABLSMOIBOXP                         0CNVI 20160826DDIC       

2 ETQ399 Requested task ID is 'COUNT_MODEFLAGS'.

3 ETQ399 Generated TQL file 'DDXTTCNT.XQL' with 1 SQL statements, log file 'DDXTTCNT.LOG'.

4 ETQ276 Executing SQL-script "DDXTTCNT.XQL"

3 ETQ120 20160828012615: PID 5688 execute 'Z:\SUM\abap\bin\SAPuptool execdb ..\var\DDXTTCNT.XQL', output written to 'Z:\SUM\abap\log\SQLSTMTSTD.OUT'.

3 ETQ123 20160828012616: PID 5688 exited with status 0 (time 0.000 real)

3 ETQ399 Reading selections from 'DDXTTCNT.LOG'.

4 ETQ399 Read 2 entries for table 'LIST'.

2 ETQ399 Found 826 times modeflag 'V'.

2 ETQ399 Found 41 times modeflag 'U'.

1EETQ399 Unhandled entries found in inactive nametab:

2EETQ399 Modeflag 'U' appears 41 times

4 ETQ010 Date & Time: 20160828012616 

1EETQ399 Last error code set is: Unhandled mode flags found, check 'PARCONV.LOG' for details

1EETQ203 Upgrade phase "PARCONV_UPG_DS" aborted with errors ("20160828012616")

The log DDXTTCNT.LOG, it show:

1 ETQ000 ==================================================

1 ETQ399 Executing SQL script '..\var\DDXTTCNT.XQL'.

2 ETQ399 Connecting to database 'syb'.

3 ETQ398 SQL: SELECT MODEFLAG, COUNT(*) FROM DDXTT GROUP BY MODEFLAG

4 ETQ393 START SELRESULT01>>

4 ETQ010 Date & Time: 20160828012616 

4 ETQ394 "V","826"

4 ETQ394 "U","41"

4 ETQ395 END SELRESULT01>>

1 ETQ000 ==================================================

4 ETQ010 Date & Time: 20160828012616 

1 ETQ003 exit code: "0"

Somebody could help me or give me some recomendation, already I am in the downtime.

thanks

Miguel Lamus

[manish_singh13 · Accepted solution]

Hi Miguel,

Can you please check below SAP Note and see if your error is same and this note solution is applicable in your scenario.

2242937 - SYB: Solution Manager upgrade with SUM fails in phase PARCONV_UPG_DS

Thanks,

Manish

[Reagan]

Connect to the system and see if there are any dumps (DBIF_DSQL2_SQL_ERROR) in Tx ST22.

If yes look for the below error

>>The error 207 occurred in the current database connection "DEFAULT".

Error Text of Database: "[ASE Error SQL207][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Invalid column name 'TYPE'.#"

SQL Statement Responsible:"SELECT ( CASE WHEN ( t1.sysstat4 & 1 ) <> 0 then 'PAGE' ELSE 'NONE' END ) FROM sysobjects t1 WHERE t1.name = ? AND t1.TYPE = 'U' AND t1.uid = ? "<<

If yes then you need to follow the solution provided in the note

2242937 - SYB: Solution Manager upgrade with SUM fails in phase PARCONV_UPG_DS

[Former Member]

Hello colleagues¡

I Apply the solution for you suggested, the process ended successfully

Thanks

Miguel Lamus