Exception has been thrown by the target of an invocation: Invalid object name 'parent_list'

Epicor ERP 10
,
1

Anyone have any pointers on finding the cause of this error? We migrated our SQL server last week from an older Server 2012 R2 server running SQL 2014 to a new Server 2019 / SQL 2019 server. Everything went well in testing and has run well all week with only this one issue.

We have an automated schedule to run the Capture process nightly and it began failing immediately after the migration. Everything else appears to be working normally. I tried to manually run the Capture to make sure that it wasn’t an issue with the system agent or schedule, but that produced the same result. The error says:

Exception has been thrown by the target of an invocation. —> System.Data.SqlClient.SqlException: Invalid object name ‘parent_list’.

I have submitted a ticket to EpicCare, but if anyone has any advice in the meantime, it would be much appreciated.

2

Are there any UD fields on the tables? Maybe you need to run the Data Model process?

3

Thanks for the suggestion, John.

I just got a reply back from Epicor that seems to have fixed my issue. For reference for anyone that runs into something similar in the future, as of 10.2.700.29, your SQL database needs to be set at a Compatibility Level of SQL 2017 (140).

The install guide lists 10.2.700 as being certified to work with Windows Server 2019 and SQL Server 2019, so that’s what we went with, but apparently the DB still needs to be set at the older SQL 2017 compatibility level. It’s certainly possible that this information was buried somewhere in the install guide, but I didn’t see it, if so.

Jay

1 Like