Object.BLOB error

IMRAN · May 12, 2007, 10:52pm

Dear All,

I am facing this strange error when i run or open some object in design mode.

This is the error i am facing

The format of the compressed file Object.BLOB Reference is invalid.

how i would solve this?

TonyH · May 13, 2007, 7:03pm

Hi Imran,

SQL or Native?

If SQL have you tried returning all rows?

/TH

IMRAN · May 14, 2007, 6:31am

SQL

What do u mean by returning all rows?

this error exists in few objects. I cant even view them in the desing view. The worst thing is that i cannot even import the old backup.

Please help further

TonyH · May 14, 2007, 2:37pm

If you can get into Enterprise manager/SQL Managment Studio, then if you navigate to a table you are having an issue with, try returning all rows in the there and see what happens. i.e. error/no error.

/TH

IMRAN · May 16, 2007, 3:18am

But my problem is with the form not the table. it is purchase order form in which there is a problem, the purchase header table is fine.

TonyH · May 16, 2007, 2:45pm

Imran,

Blob’s are normally a datatype that is used to store a picture.

Is the form you are having problems with a standard Navision form or a bespoke?

You cannot specify a BLOB global on a form. I’ve just checked 3.7 and 4.0 SP3.

So the BLOB has to come from somewhere.

Have you put the debugger on and run without triggers?
Does you form have a Widget on it for Image or Picture?
Do you have an OCX/Austomation calls related to that form?

/TH

TonyH · May 19, 2007, 3:59am

Hey Imran,

Just wondering how your issue went.

Did you resolve it?

If you did can you just let us know what you did, that way if someone else searches for the same problem in the future, they benefit from you experience.

Cheers

/TH

IMRAN · May 23, 2007, 5:59am

Hey,

Sorry for late reply. Nope , the issue is still there. I guess there is only one solution, is to delete this database , re-create from backup

I really dont know from where is error is coming. If the debugger in on, still i wouldnt see any code…I just want to know how this error can happen?

TonyH · May 23, 2007, 2:24pm

Hi Imran,

That sounds like an extreme measure.

Did you try the things I suggested?

If those still have not resolved your issue, can you export the object in question as a .txt file an post here and I’ll have a look at it.

Thanks

/TH

IMRAN · May 29, 2007, 10:48pm

Hi Tony,

I cant export this object to even as a txt file, i face the same error. I think the database has been corrupted or something.

TonyH · May 30, 2007, 3:28pm

Hey Imran,

Okay Object.“BLOB reference” is a field in the object table.

Can you delete the object from the “Object Designer” and then re-import the object from another copy of the database?

If you don’t have a “copy” of the database lying around let me know before you start and I’ll try and get a Cronus version of the object to you, I will need the version you are using as well. DB version no client.

/TH

IMRAN · June 17, 2007, 10:28pm

Sorry i was on vacation for 2 weeks. I cannot export or import the object, if i do the same error appears. I personnaly think that i have to upload the old backup, this is only solution.

FormerMember · March 10, 2008, 5:09pm

Hi!!

Do you found the source of this error? And the solution? [:)]

I get this error on Table 83, Table 82 and Codeunit 7000. The table 83 have changes but the table 82 and the codeunit dont have any change.

I’m in use NAV 4.0 SP3 PT, with SQL Server 2005. I dont have any ideia where come form this error, maybe in SQL Server.

IMRAN · March 11, 2008, 6:17am

Unfortunately i couldn’t find the source of error nor the solution. I just restored the old backup of same database. If you find anything please do tell here.