Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: balakumar86
  • Order by date
  1. balakumar86

    OTSQL help

    Hi Everyone, There are many departments. And there are some documents restricted to those departements. So, I want to search documents containing words exactly like "dept1 restricted", "dept2 restricted","dept3 restricted". There are so many departments. If I search for the documents having the...
  2. balakumar86

    OTSQL help

    Greg, Yes. You are correct. We want to perform a search like this. Regards, Bala
  3. balakumar86

    OTSQL help

    Livelinkpro, The options that I set are Look For: Complex Query Modifier: None Within: All Query String (I1 or I2 or ...) prox[0] (I1 or I2 or ...) I search with these options set. I've tried the way that you said. But, the resulting will have documents if there is a word from 1st set...
  4. balakumar86

    OTSQL help

    Appnair, Sorry. It's LQL only. What I'm doing is, I'm going to Advanced Search. Selecting "Complex Query" option from the drop down and entering the above query string and searching. Regards, Bala
  5. balakumar86

    OTSQL help

    All, I have 2 set of words. First set has M items and the second set has N items. I want to search for items having a word from the first set followed immediately by any word in the second set. I thought of using the OTSQL for this. I thought the below should work. (I1 or I2 or I3 or... Im)...
  6. balakumar86

    LAPI function to start/stop search engines.

    Appnair, We have a rule set already to stop extractor if the number of pending messages with Update Distributor goes above 250. That's not a problem for us. The problem is we don't want to run Search and Indexing at the same time as it's causing issues because of lack of resources. So, We have...
  7. balakumar86

    LAPI function to start/stop search engines.

    Appnair, What I am trying to achieve is, I need to switch off for a particular period of time daily. Currently, I am switching off/on manually. I am aiming at automating this process so that the search federator and dataflow processes stop at particular time and start at a particular time. If...
  8. balakumar86

    LAPI function to start/stop search engines.

    I am looking for LAPI function to start/stop Search Engines/Search Federator and Processes in the data flow. I couldn't find one. Is there any function for this? Regards, Bala
  9. balakumar86

    Unable to see a file via LL Client

    This has been solved by resetting the connection settings in LL client.
  10. balakumar86

    Unable to see a file via LL Client

    Hi, There is a file which is not vivible in LL client. But, the same can be seen in IE. Is it a known issue? Regards, Bala
  11. balakumar86

    Unable to edit xlsm file types

    This has been solved by adding the mime type to this entry under webedit section. MIMESupportedWebDAV2={'application/vnd.ms-excel','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','application/vnd.ms-excel.sheet.macroEnabled.12',''}
  12. balakumar86

    Unable to edit xlsm file types

    Hi, We are unable to edit files with extn XLSM. I have checked in opentext.ini. We have an entry for this Mime type in the webedit section. The below is the entry...
  13. balakumar86

    Process Error 131:Process is out of memory

    The issue is now solved. I have found one entry in the message file which was too big and occupying 3/4 of the whole message file. I've removed that entry from the message file and restarted indexing. Unluckily, there was some lock by the windows explorer on the message file and it returned...
  14. balakumar86

    Process Error 131:Process is out of memory

    Hi, Currently some of the index engines are returing this error and we are unable to run indexing. I have seen in a discussion in KC that it's due to the value set in otadmin.cfg, i.e. the amount of memory that UD is allowed to use. Anyone having any ideas? Regards, Bala
  15. balakumar86

    LL explorer slowing down MS applications

    Hi Appnair, Thanks for the response. This is particular to only one PC, not for everyone. I'll check out the configuration details of that PC. Regards, Bala
  16. balakumar86

    LL explorer slowing down MS applications

    Hi, Anyone heard of this before. When LL explorer is installed, MS Applications are functioning slowly.(i.e. Saving, closing, switching between docs are slow). If I remove LL Explorer from my machine, MS applications are working OK. Any idea? Regards, Bala
  17. balakumar86

    Unable to delete Forms

    Hi, I have a form in livelink. Sub type=227. I am not able to delete it. When I try to delete, I get the error "This node type is not supported". I have configured recycle bin to move Forms to Recycle bin and direct delete as well. Both these are not working. Any idea, where the problem is...
  18. balakumar86

    Finding size of Personal workspace of all users using SQL

    I have written both Query and PL/SQL code for this. It may be useful for someone. select A.Name, a.id, a.mailaddress, a.firstname, a.lastname, SUM(b.DataSize)/(1024*1024) from KUAF A inner join DTREE c on A.id = -c.OwnerID inner join dversdata b on b.docID = c.DataID where a.deleted = 0...
  19. balakumar86

    Finding size of Personal workspace of all users using SQL

    @Greg: Thanks. I'll try this with Cursor. @Appnair: If I couldn't achieve this myself, I'll post in OT KB as you said. Regards, Bala
  20. balakumar86

    Finding size of Personal workspace of all users using SQL

    Thanks Greg. It gives me an idea to progress with this. Now I am at this stage. Please refer to the SQL below select sum(datasize) from dversdata where docid in( select dataid from dtree start with dataid in(select dataid from dtree where subtype=142) connect by prior dataid=parentid) This...

Part and Inventory Search

Back
Top