Navision SQL error

anilkumar

Hi Experts!

facing the following error

The following SQL Server error(s) occurred while accessing the Object table:

50000,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] TECCOM\ANI5412 Checked this out.

SQL:
UPDATE "MD"."dbo"."Object" WITH (REPEATABLEREAD) SET "Modified"=1,"BLOB Reference"=NULL,"Date"={Ts ‘1754-01-01 12:40:29.128”} WHERE (“Type”=1 AND “Company name “=” AND “ID”=37) AND (“timestamp”<=0x0000000000097C6D)

Can any one help me!

ara3n

Hello Anil

The reason you are getting this error is in the error

ECCOM\ANI5412 Checked this out.

This is a sql check out I have built on the database you are working.

There is a check out table. 85001? Run the table and filter on the object you are modifying.


You'll see that somebody else has modified the same object.

Talk to the other developer and see that he is finished with modifying the object and then delete the record from the check out table. Deleting process is checking the object back in.

kine

:-) You are using MIBUSO as your internal helpdesk???

ara3n

lol.

different time zone, and we have not bee introduced I guess.

ara3n

well looking now at the error. The DOMAIN name is not familiar to me and this is only an internal code we use here. So how they got code?

Somebody must have shared it (stole it).

anilkumar

there is no check out table. 85001, and if trying to open object designer and at the time of saving it is throwing the error.

ara3n

well they have changed the table name.

What company are you working for?

anilkumar

You are using MIBUSO as your internal helpdesk??? [/quote]

MIBUSO is a Open Helpdesk not internal helpdesk, I think,

Thanks Mr. ara3n for quick respose.

anilkumar

Actually its a client Database is accessing through Citrix

kine

anilkumar wrote:

You are using MIBUSO as your internal helpdesk???

MIBUSO is a Open Helpdesk not internal helpdesk, I think,
[/quote]

It was just joke... it looked like you are asking about something and someone from same company (or partner company) is answering... 8)

ara3n

What is the client Company Name?

anilkumar

I am from India, client from North America I think, may be its your internal company/your client it seems, but I don't know, Not like somebody have shared or stole it, I got this error message to handle, I usually attend SQL navision issues and LS retail data director and some navision technical issues.

If its your internal code, then we are working for same company from different branches/ different countries.

Domain name I given as example only.

anilkumar

Yes, Check out table. 85001 is there, it means, it is not SQL related error - ?

kine

It is "SQL related", but in way, that ara3n added some trigger, which will raise the error based on the NAV table... :-) if I understand correctly... 8)

ara3n

Right. Run the table and delete the record that you are trying to modify.

The purpose of this is so that multiple people can work in the same db, and don't overwrite their mods.

anilkumar

Thanks Mr. Ara3n, you helped my lot of time, I have searched for all possible SQL related posibilities, I have not got any proper solution.

Thanks a lot.................

DenSter

That's because it's not really a SQL Server issue. It was created as an internal tool just to give a developer some sort of warning that another developer is already working with the object when you save it. It's a table trigger on the Object table that stores the user ID whenever an object is saved, and it causes a SQL error when another user tries to save the same object. By deleting that record, you can free up the object.