I was upgrading SCCM hierarchy from CB1610 to CB1706 and encountered below error message while upgrading CAS server. the database upgrade was failed.

Issue:

"ERROR: FAILED to Import Data to Table LU_SoftwareList"

and

"Failed to Update Database."

 

Resolution:

To resolve this issue, open SQL management studio and under SCCM database find out the problem table that was failed to execute.

once found, DROP the table. No Worry, it will be re created/added during upgrade.

Retry the Upgrade from SCCM Console. this time upgrade was completed successfully.