http://www.baanboard.com/baanboard/showthread.php?p=79250#poststop

Continued to above post...i am also facing similar problem.
We have a customised table. And it is get locked. Even after restarting baan and database server it is in locked condition. I want to import some data in this table. It is not allowing me to change / modify and insert.

How to unlock this table. My database is SQL7. Attached Window NT event view log detail. The error is 1000 - and 850 (Transaction rolled back) db.eq

BR/

Manish

The document you supplied is that the database is not on. When do you get the error?

No. It when my database is open and i am trying to modify record VIA GTM. The error is Window NT event viewer log details.

This morning also i have restarted the server so everthing is working fine but for this table i am getting following error message while updating through GTM -
1:Process 5 - Fatal Error - Transaction rolled back. Please try again. (ttdvml070100)
2:Process 5 - Fatal Error - Cannot continue in ttaad4100 (ask.enum)

Will Reorg table help --ttaad4225m000 ???

Restart the DB should work I believe.

Doing restart every morning.....But cant unlock the table....

1:Process 5 - Fatal Error - Transaction rolled back. Please try again. (ttdvml070100)

Hi,

the Transaction roll back also occurs due to dead locks . check your Cust.program / session and try analyzing the clashing of resources that causes DEAD LOCK.

(if its oracle - you could simple check alert logs)
I am good with Oracle,sql 2000 but not with SQL 7, so any other member may throw some light or google it for SQL7 analysis tools.

Note : in sql 2000 - you have a procedure sp_lock - check the same with sql 7 , when it is locked.
also try - http://support.microsoft.com/kb/q169960/

BR,
Sushil Kumar Mudaliar

Hi Sushil,

Thanks for your suggestion. I went in SQL7 enterprise Manager. Surprisingly i could not see the stored procedure for this table for live company (pttdvml070100). 100 is our live company and few months back there was similar problem in uploading data in table
tdvml070. And at that time i remember the procedure for the same was deleted. But at that time data was getting uploaded through exchange scheme.
Can you tell me in brief what does this stored procedure does and how to retrieve this for company 100? (You can tell me on the basis of SQL2000)

Regards,

Manish

Hi,

Plz be informed ,as per my understanding - all the SQL SP recides in master only.

the link below explains the procedure.

http://msdn.microsoft.com/en-us/library/aa238824(SQL.80).aspx

BR,
Sushil Kumar Mudaliar

Hi,
I have created a Stored Procedure for my table , which was missing. And now i can modify any record in table.
The problem is resolve.

Thanks

Kindly Post the Solution in terms of :

1.Stored procedure name.
2.Script that restored the procedure.

So it could be reffered back , in case if any one faces the same kind of problem.

Thanks for understanding.

The Stored Procedure name is -pttdvml070100_1 and the script is as below...


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
CREATE PROCEDURE dbo.Pttdvml070100_1
@hash1 BINARY(23),
@mode smallint
AS
if @mode = 1
begin
SELECT t_item, t_opstk, t_cwar, t_opamnt, t_opdate, t_opfloor, t_opfval, t_Refcntd, t_Refcntu, hash1 FROM dbo.ttdvml070100 (NOLOCK FASTFIRSTROW INDEX=Ittdvml070100_1a) WHERE hash1 = @hash1
return
end
if @mode = 2
begin
SELECT t_item, t_opstk, t_cwar, t_opamnt, t_opdate, t_opfloor, t_opfval, t_Refcntd, t_Refcntu, hash1 FROM dbo.ttdvml070100 (UPDLOCK FASTFIRSTROW INDEX=Ittdvml070100_1a) WHERE hash1 = @hash1
return
end
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Hope this should help....

Regards,

Manish Chheda

Now I understand how you get this locking issue. I thought that nobody used the Level 1 driver nowadays, but this explains a lot.
Good you found it, hope you never run into this issue again.
Thanks for your explanation, it refreshed my mind.

Regards,
Dick

u can restart the shared memory