Notes Error Specified Database Is Not Currently Open
may appear when you attempt to use LotusScript to copy and save attachments from one rich text field to another Technote (troubleshooting) Problem When you use LotusScript to copy attachments from a rich text field from one database to another database in a WebQuerySave event, and the source database has not already been opened by any user in client or browser, the error "HTTP error -Specified database is not currently open" may appear. The following sample code demonstrates this issue in a WebQuerySave event. Sub Initialize Dim s As New NotesSession Dim Ddoc As NotesDocument Dim Sdoc As NotesDocument Dim Drtfi As NotesRichTextItem //Destination RTF field Dim Srtfi As NotesRichTextItem //Source RTF field which only include some attachments that we want to copy them. Dim Sdb As NotesDatabase Dim view As NotesView Set Ddoc = s.Documentcontext Set Drtfi = Ddoc.Getfirstitem("test") Set Sdb = s.Getdatabase(Ddoc.Parentdatabase.Server, "test1.nsf", false) Set view = Sdb.Getview("test") Set Sdoc = view.Getfirstdocument() Set Srtfi = Sdoc.Getfirstitem("test") Call Drtfi.Appendrtitem(Srtfi) //Append the attachments to Destination RTF field End Sub If you use code similar to the preceding example in a WebQuerySave event, the server console displays the error. Resolving the problem Workaround: Detach the attachments to disk and attach them to another rich text field. For more details, see technote #1109976: Using LotusScript to move attachments or objects from one field to another http://www-01.ibm.com/support/docview.wss?rs=899&uid=swg21109976 Related information Using LotusScript to move attachments or objects from o Document information More support for: IBM Domino Database Software version: 6.0, 6.5, 7.0, 8.0, 8.5, 9.0 Operating system(s): AIX, IBM i, Linux, Solaris, Windows, z/OS Software edition: All Editions Reference #: 1655020 Modified date: 07 December 2013 Site availability Site assistance Contact and feedback Need support? Submit feedback to IB
Training Support Forums & community Events Rational Tivoli WebSphere Java technology Linux Open source SOA and Web services Web development XML My developerWorks About dW Submit content Feedback developerWorks>Lotus>Forums & community>Notes/Domino 6 and 7 Forum Notes/Domino 6 and 7 Forum Error: Specified database is not currently open Sign in to participate Error: Specified database is not currently open Posted by Rob Lardenoye on 11.Dec.06 at 12:25 PM using a Web browserCategory: Notes ClientRelease: 6.5.4Platform: Windows NT Hi, Can somebody help me please. I have a document in a library containig attachments. When I http://www.ibm.com/support/docview.wss?uid=swg21655020 create in the background a new document, having a body field and want to append the attachments in the rt item on the library onto the body field on the new created document with the .AppendRTItem I have some strange behaviour. The new document is saved in the background, and opened in ui with a ws.EditDocument, when I try to save it it gives me the http://www-10.lotus.com/ldd/nd6forum.nsf/0/8ce575263418ea0d85257241005faff5?OpenDocument error. When I close the document (without saving) and reopen it, it works fine. Can somebody give me a hint pleeeeeeease. Thanks in advance Robert Return to top Error: Specified database is not cu... (Rob Lardenoye 11.Dec.06) . . RE: Error: Specified database is no... (James W. Stuart... 11.Dec.06) . . . . RE: Error: Specified database is no... (Rob Lardenoye 12.Dec.06) . . Found a workaround (Rob Lardenoye 12.Dec.06) Document options Print this page Search this forum Forum views and search Date (threaded) Date (flat) With excerpt Author Category Platform Release Advanced search Sign In or Register Sign in Forgot your password? Forgot your user name? Create new registration RSS feeds All forum posts RSSAll main topics RSSMore Lotus RSS feeds Resources Resources Forum use and etiquette Native Notes Access Web site Feedback Lotus Support Lotus Support IBM Support Portal - Lotus software Lotus Support documents Lotus support by product Lotus support downloads Lotus support RSS feeds Wikis Wikis IBM Composite Applications IBM Mashup Center IBM Connections IBM Connections Cloud Developers IBM Docs IBM Forms IBM Mobile Connect IBM Sametime IBM SmartCloud for Social Business IBM Web Experience Factory Lotus Domino Lotus Domi
Administration View All Domino Directory Administration Tools AdminP LDAP Calendar and Contact Management Interoperability Licensing Monitoring and Logging User Settings Notes.ini IBM Lotus Messaging and Collaboration Clients View All http://searchdomino.techtarget.com/feature/Troubleshooting-common-Lotus-Notes-Domino-error-messages Domino Web Access (iNotes) Lotus Notes 5 Lotus Notes 6 Lotus Notes 7 Lotus Notes 8 Lotus Sametime Instant Messaging Mobile Devices IBM Lotus Messaging and http://nedbatchelder.com/blog/200212/huffman_compression_in_notes.html Collaboration Servers View All IBM WebSphere Lotus Domino Server 5 Lotus Domino Server 6 Lotus Domino Server 7 Lotus Domino Server 8 Lotus Quickr Notes/Domino Administration notes error View All Domino Directory Administration Tools AdminP LDAP Calendar and Contact Management Interoperability Licensing Monitoring and Logging Performance User Settings Notes.ini Notes/Domino Coding and Development View All Ajax Development Security Eclipse HTML J2EE Java JavaScript LEI and DECS Domino Designer Agents Application Development Formula LotusScript Mobile and Wireless Development Web Development notes error specified XML and Web Services Notes/Domino Data Management and Storage View All Archiving Backup and Recovery Clustering Database Management Hardware Management Mailbox Management Replication and Synchronization Storage Management Notes/Domino Deployment and Migration View All Deployment and Migration Advice Deployment and Migration Tools Notes/Domino Security View All Compliance Management Compliance tools Access, Permissions and Authentication Antispam Software and Spam Filtering Antivirus Software and Virus Protection Email Compliance Email Encryption Firewalls Password Management Phishing and Email Fraud Protection Policy Management Topics Archive View All Domino Resources Domino Resources - Part 2 Domino Resources - Part 3 Domino Resources - Part 4 Domino Resources - Part 5 Domino Resources - Part 6 Domino Resources - Part 7 Domino Resources - Part 8 Please select a category IBM Lotus Messaging and Collaboration Clients IBM Lotus Messaging and Collaboration Servers Notes/Domino Administration Notes/Domino Coding and Development Notes/Domino Data Management and Storage Notes/Domino Deployment and Migration Notes/Domino Security Section Proble
attachments in Notes?The answer is: you can't. The Notes C API provides no facility to do this, and Lotus (or IBM or Iris, or whatever they should be called now) has never documented the compression algorithm. The only way to decompress these attachments is to use the C API functions NSFNoteExtractFile or NSFNoteExtractFileExt. Both of these functions take a filename, and the decompressed data is written to the file. Of course, this is really stupid. For one thing, when writing high-throughput software, the last thing you want to do is write more data to disk. If I need to process the data in a file attachment, I want a way to read the data into memory, and writing it to a temp file just to read it back in so I can do whatever to it, is just wasteful.Of course, IBM (or Lotus or Iris, or whatever) has functions to do the decompression, they just haven't been exposed as part of the C API.I used to work at Iris (or Lotus, or whatever), but I don't know how the compression works, or what the functions are to do the decompression. I'd like to have access to them as well, but I'm in the same boat as everyone else. tagged: lotus» 1 reaction Comments sendhil 9:59 AM on 16 Dec 2004 Hi Ned, I really am in trouble trying to use the NSFNoteExtractFile. I could not ask anyone else other than yourself. I have seen all the posts on notes.net and none seem to give me a working answer. The requirement is quite simple. Detach attachments to a folder of all the messages going through a mail box. I have written a extension manager and that goes through all the $FILE items one by one using the NSFItemInfo and NSFItemInfoNext and for every BLOCKID it finds it tries to call NSFNoteExtractFile. Just before I call NSFNoteExtractFile i also find the name of the original attachment using the FILEOBJECT structure read from the items value BLOCKID. I always get the same error "Specified database is not currently open". Now the documentation says that if the extension manager event is EM_BEFORE then all the handles will be valid. So i have tried it on EM_BEFORE and EM_AFTER. Nothing seems to be working. I can mail you the entire source code if you want. But please...please..help. I will post your solution to notes.net and you will be helping not only me but quite a few people. Thanks in advance. Add a comment: name email Ignore this: not displayed and no spam. Leave this empty: www not searched. Name and either email or www are required. Don't put anything here: Leave this empty: URLs auto-link and some tags are allowed: . Email me future comments Search this site: About meAlso me: