Table Update error

Question

I am trying to update my table called members in Microsoft SQL server management Studio but I keep getting an error. The Table is from M-Files. I have already synchronized my metadata using MFSQL.``

This is the query

EXEC [spMFUpdateTable] @MFTableName = 'MFMembers'
  , @UpdateMethod = 1
  , @debug = 0

This is the error i keep getting:

Msg 8179, Level 16, State 5, Procedure sp_xml_removedocument, Line 1 [Batch Start Line 0]
Could not find prepared statement with handle 87.

Please help.

Answer 1

Good day Simon,

The error is probably coming from your SQL Server but the source of the problem related to code which included in the stored procedure which you use spMFUpdateTable

Without seeing the code we cannot know what the course of the issue is.

As Tom said, you should contact the company which provide you the service that include this SP which is probably part of MFSQLConnector product:
https://lamininsolutions.atlassian.net/wiki/spaces/MFSQL/pages/31817730/spMFUpdatetable+Class+Table+Records

Note! the stored procedure sp_xml_removedocument is a build-in SP in the server and the error is probably coming from the SQL Server, but "why" is related to the code that you execute (the third party SP)

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-xml-removedocument-transact-sql?view=sql-server-ver15

Answer 2

This is apparently related to MFSQLConnector. This is not a Microsoft Product. I suggest you contact the vendor for support.

Answer 3

Hi @Simon Katimba ,

As others mentioned, the problem related to code which included in the stored procedure which you use spMFUpdateTable. Did you contact the company which provide you the service that include this SP.

By the way, if the reply from others helped , please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.