This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 74%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWH%3C/text%3E%3C/svg%3E)
Hi all, I have a problem updating my SCCM CB 2002 to 2010 or 2103, there's an error regarding to a table in the database of sccm, I've deleted the table, recreated index, nothing works :(
INFO: Starting data import data to table: LU_SoftwareList CONFIGURATION_MANAGER_UPDATE 5/4/2021 11:33:13 AM 16420 (0x4024)
* BCP fails due to internal sql error. Check if this table has a trigger failed to execute. CONFIGURATION_MANAGER_UPDATE 5/4/2021 11:52:42 AM 16420 (0x4024)
* bcp_batch() failed CONFIGURATION_MANAGER_UPDATE 5/4/2021 11:52:42 AM 16420 (0x4024)
ERROR: Failed to send batched rows. CONFIGURATION_MANAGER_UPDATE 5/4/2021 11:52:42 AM 16420 (0x4024)
ERROR: SQL Server error: <> CONFIGURATION_MANAGER_UPDATE 5/4/2021 11:52:42 AM 16420 (0x4024)
ERROR: FAILED to import data to table LU_SoftwareList CONFIGURATION_MANAGER_UPDATE 5/4/2021 11:52:42 AM 16420 (0x4024)
ERROR: Failed to import data from CSV files CONFIGURATION_MANAGER_UPDATE 5/4/2021 11:52:42 AM 16420 (0x4024)
ERROR: Failed to import Asset Intelligence data into the site database. CONFIGURATION_MANAGER_UPDATE 5/4/2021 11:52:42 AM 16420 (0x4024)
Failed to update database. CONFIGURATION_MANAGER_UPDATE 5/4/2021 11:52:42 AM 16420 (0x4024)
STATMSG: ID=11001 SEV=E LEV=M SOURCE="SMS Server" COMP="CONFIGURATION_MANAGER_UPDATE" SYS=PVMSAPP046.PICHINCHA.LOCAL SITE=PCH PID=19376 TID=16420 GMTDATE=Tue May 04 16:52:42.660 2021 ISTR0="6B4F84B7-5555-48B0-AECC-74FB5A8AA24B" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 LE=0X0 CONFIGURATION_MANAGER_UPDATE 5/4/2021 11:52:45 AM 16420 (0x4024)
Note: connectivity to SQL works fine
You should not poke the SQL database manually. Maybe try to update first to the lowest version out there, 2006? Also check, if you have CUs available for your SQL as well. Otherwise you just need to open MS premium ticket and ask them to help.
Hi, @William Hernandez
Thank you for posting in Microsoft Q&A forum.
It looks like your issue is similar to below thread, the issue fixed by recreating the index but not delete the table:
https://social.technet.microsoft.com/Forums/Lync/en-US/ac45609a-2681-4695-a97a-7b08f1648e37/configuration-manager-1606-installation-failed?forum=ConfigMgrCBGeneral
However, it's not supported to modify the database by ourselves, and servicing support is not available for issues that are caused by custom changes to the database.
https://learn.microsoft.com/en-us/troubleshoot/mem/configmgr/support-policy-for-manual-database-changes
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Huge +1 to Allen's last statement there. You have impacted the supportability of the site as a whole will almost certainly have to restore the site from backup and then open a support ticket to address the issue.
Hi all, I've already tried recreating the index, It did not work, I'm gonna restore the site and let's see what happens.
Thanks.
Hi,@William Hernandez
After restore the site, you may open a support ticket like Jason said, here is the link of CSS support:
https://support.microsoft.com/en-us/hub/4343728/support-for-business
Update: I've restored the DB, the site, and nothing works, finally we figure out that the DB and SCCM site server are in different VLAN, we checked with firewall Guys (Palo Alto Fw) and there was a rule blocking file upload after the rule was fixed everything is working as expected.
Thanks to all.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 62%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIF%3C/text%3E%3C/svg%3E)
I had the exact same problem. As recommended by above post, I disabled the windows firewall to test and as soon as I did it, the SCCM installation futher continued (the ConfigMgrSetup.log file) immediately and completed the setup of the SCCM site successfully. It is 100% a firewall issue. Thank you for all the help - ******@hotmail.com