Error adding a document

[pjb]

I can add a .doc type with no problem. However, when I try to add a picture(.jpg file) or when I try to add a version to an existing .doc file I get
"Cannot insert value NULL into column 'ProviderData', table livelink.dbo.ProviderData; column does not allow nulls. INSERT fails. I should add this is a new instance of Livelink that we are moving to a new server, copying the data files from the old server and re-building the data base from the backup file. It is a MSSQL7 database. I do not get this error on the old machine

 

[appnair]

The only thing that comes to mind is this.In 9.5SP1 they have a new way of doing EFS.Instead of a hard coded path now they have an assoc.
For eg please pick a new document ID and an old document id
and run this query

SELECT a.docid ,a.versionid,a.version,a.vermdate,a.providerid ,b.PROVIDERTYPE,b.providerdata from dversdata a,providerdata b WHERE a.docid = %1 and a.providerid=b.providerid order by version desc

its output as an example
DOCID VERSIONID VERSION VERMDATE PROVIDERID PROVIDERTYPE PROVIDERDATA
46730718 46730718 1 10/13/2005 02:29 PM 46730718 Default A<1,?,'providerInfo'='0046\\730\\46730718.dat','storageProviderName'='ExtShared','subProviderName'='Default'>

In the older document id's you will just see a path like
0046\\730\\ and so on.The livelink server process user ,do they have read,write on this new EFS,is the top level EFS entry looking correct.
In other words if your old database said for dataid=1234 I am storing it at 0046\\730\\1234.dat,livelink streams it by appending the UNC or path component that yous set up.So for eg if you had set up C:\MyExternalFileStore
livelink is trying to stream the file from
C:\\MyExternalFileStore\\0046\\730\\1234.dat so when you are redoing your datafiles and have a new high level folder
the hirarchy needs to remain right.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937

 

[appnair]

Most problems are really probably due to the livelink server process (llserver)users ability to write to the exteranl file store.Since you say that you can add new documents I would assume that you have correctly set Read/Write on them otherwise that should fail as well.
If after checking things sanely possible still don't work
open a tciket with OT support or run logs yourself to see
if you can get it right.One more thing you did rememebr to change the EFS in the new install.Otherwise probably your new livelink server is trying to write to the old efs itself.


Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937