LLAttrData and LLAttrBlobData

Francisco_Alcala-Soler_(iaea_001user3_-_(deleted))

Message from via eLinkHi,Apropos Alex Kowalenko and Shashank Ambekar's recent discussion oncategory/attribute direct accesses, a colleague has inadvertently wiped theLLAttrData table from his development installation. Is there any script(whether SQL or Oscript) to repopulate it from LLAttrBlobData?Thanks, CurroThis email message is intended only for the use of the named recipient.Information contained in this email message and its attachments may beprivileged, confidential and protected from disclosure. If you are not theintended recipient, please do not read, copy, use or disclose thiscommunication to others. Also please notify the sender by replying to thismessage and then delete it from your system.

Find more posts tagged with

Comments

Alex_Kowalenko_(akowalen_(Delete)_2285456)

Message from Alex Kowalenko via eLinkLLAttrData table data is always recreated on-the-fly from LLAttrBLOBData sothere is no impact on normal browse operations for individual nodes.However, Live and Web Reports will not work until the whole table isrecreated. From the Livelink user interface you can do this by upgrading allcategories. From OScript, you can write (or beg, or borrow, or buy) a methodto call the AttrData API for all categorized nodes. From SQL you have achallenge to decode the LLAttrBLOBData Assoc structure.-alex------Original Message-----From: eLink Discussion: Development Discussion[mailto:development@elinkkc.opentext.com]Sent: Tuesday, June 22, 2004 9:25 AMTo: eLink RecipientSubject: LLAttrData and LLAttrBlobDataLLAttrData and LLAttrBlobDataPosted by Alcala-Soler, Francisco J on 06/22/2004 09:24 AMMessage from via eLinkHi,Apropos Alex Kowalenko and Shashank Ambekar's recent discussion oncategory/attribute direct accesses, a colleague has inadvertently wiped theLLAttrData table from his development installation. Is there any script(whether SQL or Oscript) to repopulate it from LLAttrBlobData?Thanks, CurroThis email message is intended only for the use of the named recipient.Information contained in this email message and its attachments may beprivileged, confidential and protected from disclosure. If you are not theintended recipient, please do not read, copy, use or disclose thiscommunication to others. Also please notify the sender by replying to thismessage and then delete it from your system.[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Development Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=786303&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe

Francisco_Alcala-Soler_(iaea_001user3_-_(deleted))

Message from via eLinkThanks, Alex.> However, Live and Web Reports will not work until the whole table is> recreated. From the Livelink user interface you can do this > by upgrading all> categories.Even if it is a dummy upgrade which doesn't actually add or remove anything?I will give it a try. It sounds simple.> From OScript, you can write (or beg, or borrow, > or buy) a method> to call the AttrData API for all categorized nodes.I didn't know that calling the API would actually update the table. I canwrite something like this, although begging is precisely what I was doingwhen I wrote my message ;-)> From SQL you have a> challenge to decode the LLAttrBLOBData Assoc structure.Yes, too much string parsing; even reading the Assocs into Oscript andinstantiating them sounds like a lot. The first method is preferred. Thanksa lot. CurroThis email message is intended only for the use of the named recipient.Information contained in this email message and its attachments may beprivileged, confidential and protected from disclosure. If you are not theintended recipient, please do not read, copy, use or disclose thiscommunication to others. Also please notify the sender by replying to thismessage and then delete it from your system.