cancel
Showing results for 
Search instead for 
Did you mean: 
jmcg
Level 9
Report Inappropriate Content
Message 1 of 16

ePO 5.10 - Could not find stored procedure 'EPO_ComputerPropsStagingFlush'

Jump to solution

Hello,

My client with McAfee Agent 5.5.1 does not report IP and other information about the system OS.

In my server.log i have an error call:

 

20190118092240	E	#00320	EPODAL  	ePOData_Connection.cpp(865): COM Error 0x80040E14, source=Microsoft SQL Server Native Client 11.0, desc=Could not find stored procedure 'EPO_ComputerPropsStagingFlush'., msg=IDispatch error #3092
20190118092240	E	#00320	NAIMSERV	common\AgentHandlerDAO.cpp(574): COM Error 0x80040E14, source=Microsoft SQL Server Native Client 11.0, desc=Could not find stored procedure 'EPO_ComputerPropsStagingFlush'., msg=IDispatch error #3092

 

Do you have any KB about this issue ?

 

Thanks.

2 Solutions

Accepted Solutions
McAfee Employee Hawkmoon
McAfee Employee
Report Inappropriate Content
Message 2 of 16

Re: ePO 5.10 - Could not find stored procedure 'EPO_ComputerPropsStagingFlush'

Jump to solution

Hi jmcg,

Your epo install, does it have CU2 (or 1) installed?

What you describe looks/sounds very mush like item ref: 1253492
See below artilce for CU2 (details in the CU1 update section)

  • ePolicy Orchestrator 5.10.0 Update 2 Release Notes
    Product Documentation ID: PD28102

Was my reply helpful?

If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 16 of 16

Re: ePO 5.10 - Could not find stored procedure 'EPO_ComputerPropsStagingFlush'

Jump to solution

Glad to hear it.

For anyone else following this thread, the domain was entered as domain.com.

Change it to use just domain name without the .com and it worked.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

15 Replies
McAfee Employee Hawkmoon
McAfee Employee
Report Inappropriate Content
Message 2 of 16

Re: ePO 5.10 - Could not find stored procedure 'EPO_ComputerPropsStagingFlush'

Jump to solution

Hi jmcg,

Your epo install, does it have CU2 (or 1) installed?

What you describe looks/sounds very mush like item ref: 1253492
See below artilce for CU2 (details in the CU1 update section)

  • ePolicy Orchestrator 5.10.0 Update 2 Release Notes
    Product Documentation ID: PD28102

Was my reply helpful?

If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

jmcg
Level 9
Report Inappropriate Content
Message 3 of 16

Re: ePO 5.10 - Could not find stored procedure 'EPO_ComputerPropsStagingFlush'

Jump to solution

I have the build : Version : 5.10.0.2428


I cannot uninstall the update CU2 when i tried to install CU2 it always fail. 

 

EDIT : CU2 Installed, ip and OS info are displayed.

PMorin
Level 8
Report Inappropriate Content
Message 4 of 16

Re: ePO 5.10 - Could not find stored procedure 'EPO_ComputerPropsStagingFlush'

Jump to solution

I have the same issue, the update fails and then my server log is filled with:

20190123134701 E #02804 EPODAL ePOData_Connection.cpp(865): COM Error 0x80040E14, source=Microsoft SQL Server Native Client 11.0, desc=Could not find stored procedure 'EPO_ComputerPropsStagingFlush'., msg=IDispatch error #3092
20190123134701 E #02804 NAIMSERV common\AgentHandlerDAO.cpp(574): COM Error 0x80040E14, source=Microsoft SQL Server Native Client 11.0, desc=Could not find stored procedure 'EPO_ComputerPropsStagingFlush'., msg=IDispatch error #3092

 

EPO seems to work properly....

 

McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 5 of 16

Re: ePO 5.10 - Could not find stored procedure 'EPO_ComputerPropsStagingFlush'

Jump to solution

What is the failure in the update log when you run it?  It will eventually cause some issues, such as missing info in the system tree and other possible side effects.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

PMorin
Level 8
Report Inappropriate Content
Message 6 of 16

Re: ePO 5.10 - Could not find stored procedure 'EPO_ComputerPropsStagingFlush'

Jump to solution

The 2 sql line at the top of the result upgrade page

McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 7 of 16

Re: ePO 5.10 - Could not find stored procedure 'EPO_ComputerPropsStagingFlush'

Jump to solution

Not sure what you are referring to there.  I am referring to the log that is generated when you run update2.  It should be in the %temp%\mcafeelogs directory.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

McAfee Employee cdinet
McAfee Employee
Report Inappropriate Content
Message 8 of 16

Re: ePO 5.10 - Could not find stored procedure 'EPO_ComputerPropsStagingFlush'

Jump to solution

If you don't find it there, look in the address bar of windows explorer.  It may have put you in a session directory, such as temp\2\mcafeelogs.  Back up to the root of temp, then to that mcafeelogs directory.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

PMorin
Level 8
Report Inappropriate Content
Message 9 of 16

Re: ePO 5.10 - Could not find stored procedure 'EPO_ComputerPropsStagingFlush'

Jump to solution
Here is a part of it:
2019-01-23T16:46:25.661Z - error: Failed to get connection..ConnectionError: Failed to connect to EPO-SVR-SQL:1433 in 15000ms
2019-01-23T16:46:25.661Z - info: Failed to update record for snapshot with updateIDCU-2
2019-01-23T16:46:25.662Z - error: Failed to get connection..ConnectionError: Failed to connect to EPO-SVR-SQL:1433 in 15000ms
2019-01-23T16:46:25.663Z - info: Failed to update record for snapshot with updateIDCU-2
2019-01-23T16:46:25.663Z - error: Failed to get connection..ConnectionError: Failed to connect to EPO-SVR-SQL:1433 in 15000ms
2019-01-23T16:46:25.664Z - info: Failed to update record for snapshot with updateIDCU-2
2019-01-23T16:46:25.720Z - error: Failed to get connection..ConnectionError: Failed to connect to EPO-SVR-SQL:1433 in 15000ms
2019-01-23T16:46:25.720Z - info: Failed to update record for snapshot with updateIDCU-2
2019-01-23T16:46:25.721Z - error: Failed to get connection..ConnectionError: Failed to connect to EPO-SVR-SQL:1433 in 15000ms
2019-01-23T16:46:25.721Z - info: Failed to update record for snapshot with updateIDCU-2
2019-01-23T16:46:25.721Z - error: Failed to get connection..ConnectionError: Failed to connect to EPO-SVR-SQL:1433 in 15000ms
2019-01-23T16:46:25.722Z - info: Failed to update record for snapshot with updateIDCU-2
2019-01-23T16:46:25.730Z - error: Failed to get connection..ConnectionError: Failed to connect to EPO-SVR-SQL:1433 in 15000ms
2019-01-23T16:46:25.730Z - info: Failed to update record for snapshot with updateIDCU-2
2019-01-23T16:46:25.731Z - error: Failed to get connection..ConnectionError: Failed to connect to EPO-SVR-SQL:1433 in 15000ms
2019-01-23T16:46:25.731Z - info: Failed to update record for snapshot with updateIDCU-2
2019-01-23T16:46:25.732Z - error: Failed to get connection..ConnectionError: Failed to connect to EPO-SVR-SQL:1433 in 15000ms
2019-01-23T16:46:25.732Z - info: Failed to update record for snapshot with updateIDCU-2
2019-01-23T16:46:25.733Z - error: Failed to get connection..ConnectionError: Failed to connect to EPO-SVR-SQL:1433 in 15000ms
2019-01-23T16:46:25.733Z - info: Failed to update record for snapshot with updateIDCU-2
2019-01-23T16:46:25.839Z - info: Going to execute rollback script..C:/PROGRA~2/McAfee/EPOLIC~1/updates/CU-2/down/ePO_5100_CU1_Rollback.sql
2019-01-23T16:46:25.839Z - info: going to execute sql down/ePO_5100_CU1_Rollback.sql
2019-01-23T16:46:25.840Z - info: Sql filedown/ePO_5100_CU1_Rollback.sql has 5 chunks
2019-01-23T16:46:25.849Z - info: Going to execute rollback script..C:/PROGRA~2/McAfee/EPOLIC~1/updates/CU-2/down/ePO_5100_CU2_Rollback.sql
2019-01-23T16:46:25.849Z - info: going to execute sql down/ePO_5100_CU2_Rollback.sql
PMorin
Level 8
Report Inappropriate Content
Message 10 of 16

Re: ePO 5.10 - Could not find stored procedure 'EPO_ComputerPropsStagingFlush'

Jump to solution
But my SQL works fine and always has, but update process doen't like it....
More McAfee Tools to Help You
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • Visit: Business Service Portal
  • More: Search Knowledge Articles
  • ePolicy Orchestrator Support

    • Download the new ePolicy Orchestrator (ePO) Support Center Extension which simplifies ePO management and provides support resources directly in the console. Learn more about ePO Support Center