The stored procedure smgetnextnoteindex returned the following results: DBMS: 1205, Microsoft Dynamics GP:0.

(0) Share

Report

Posted on by Sameer Ahmed

Hi,

We are getting this error message when we post in GP: The stored procedure smgetnextnoteindex returned the following results: DBMS: 1205, Microsoft Dynamics GP:0.

Any Suggestions

Thanks,

Sameer

*This post is locked for comments

All responses (3)

Answers (0)

GovindDevda

615 on at

Like (0)

Report

RE: The stored procedure smgetnextnoteindex returned the following results: DBMS: 1205, Microsoft Dynamics GP:0.

Hey Sameer Just fire this procedure in your company database

SET ANSI_NULLS ON
GO
SET ANSI_NULLS ON
GO
create procedure smDEX_Clear_Locks @I_Session_id int as delete from tempdb..DEX_LOCK where tempdb..DEX_LOCK.session_id = @I_Session_id return
GO
SET ANSI_NULLS OFF
GO

Hope this is useful for you !!

Regards,

Govind Devda

Jonathan Fear on at

Like (0)

Report

Re: The stored procedure smgetnextnoteindex returned the following results: DBMS: 1205, Microsoft Dynamics GP:0.

Dexsql.log is needed for this type of an error. As Ian noted this could be a deadlock issue. Try having all users log out of the system and restart the SQL instance.
Community Member on at

Like (0)

Report

Re: The stored procedure smgetnextnoteindex returned the following results: DBMS: 1205, Microsoft Dynamics GP:0.

Hi Sameer - well first off its a SQL error, and its a 'Deadlock' error I believe. Deadlocks happen when two processes are trying to access a resource where one process has it locked. SQL rolls back the process that has the least amount completed.

Somewhere in Customersource there is a KP on the above error. You could try looking there.

Can you post successfully logged in as 'sa'?

Ian.