|
This is a multipart message in MIME format. -- [ Picked text/plain from multipart/alternative ] I searched the notes knowledge base and found no answers. Then I searched the following and found a few hits: http://notes.net/46dom.nsf?OpenDatabase But no solutions. Well, several great suggestions, but actually only one solution. Add journalling to the file. If you come up with an alternative would you post it to that link? Gotta get that iseries info out there. Rob Berendt -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin DaveBednarcik@westernunion.com Sent by: domino400-admin@midrange.com 04/17/2002 01:12 PM Please respond to domino400 To: domino400@midrange.com cc: Fax to: Subject: Re: Script Error Just to let you know, I tried this on another file that is being journaled and it did work. Based on this it appears that journaling is the issue. I also have a call into Lotus Support. Thanks for the help. Dave Bednarcik Email: DaveBednarcik@WesternUnion.com Work #: (201)263-5186 Fax # : (201)263-5455 rob@dekko.com Sent by: To: domino400@midrange.com domino400-admin@m cc: idrange.com Fax to: Subject: Re: Script Error 04/17/2002 12:25 PM Please respond to domino400 This is a multipart message in MIME format. -- [ Picked text/plain from multipart/alternative ] As I said earlier, I don't see how. If you do the DSPMSGD you will see: -- Code 3 -- &1 not journaled, or no authority to the journal. Files with an RI constraint action of CASCADE, SET NULL, or SET DEFAULT must be journaled to the same journal. RI constraint actions of CASCADE, SET NULL and SET DEFAULT are only called upon a deletion. For example, If I have an order header file, and an order line file, I can set up an RI that no order line may exist if there is no matching order number in the order header. Then, if I have journalling all set up, I can set up the RI to do a number of things if I try to delete an order header, which contains matching lines. I can have it: fail, delete all the children with matching order numbers, null out all the matching order numbers in the line file, or set the matching order numbers to the default value. Now, maybe I am reading this wrong. Perhaps I should be reading this as: -- Code 3 -- &1 not journaled, or no authority to the journal. -- Code 3.5 -- Files with an RI constraint action of CASCADE, SET NULL, or SET DEFAULT must be journaled to the same journal. but I don't think I am misreading this. I still think you need to look at the whole DSPMSGD and check the other possible scenarios first. Lotus may have done you a disservice by saying "This error is most common when the table is...". Because, now that has you focusing on journals only. Rob Berendt -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin DaveBednarcik@westernunion.com Sent by: domino400-admin@midrange.com 04/17/2002 09:26 AM Please respond to domino400 To: domino400@midrange.com cc: Fax to: Subject: Re: Script Error Would the fact that the file that I am inserting to is not being journaled be an issue. Thanks, Dave Bednarcik Email: DaveBednarcik@WesternUnion.com Work #: (201)263-5186 Fax # : (201)263-5455 rob@dekko.com Sent by: To: domino400@midrange.com domino400-admin@m cc: idrange.com Fax to: Subject: Re: Script Error 04/17/2002 09:48 AM Please respond to domino400 This is a multipart message in MIME format. -- [ Picked text/plain from multipart/alternative ] I did a DSPMSGD RANGE(SQL7008) MSGF(QSQLMSG). There are numerous things that could be causing that message. Look at this message carefully and investigate all of the possibilities. You might have to look at the job log of the server job processing the script to see exactly which error is occurring. I am doubting that it is the journal option - code 3. Because you are doing an insert and nothing that would cause the described RI constraints to kick in. Those would normally kick in during a delete. Rob Berendt -- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." Benjamin Franklin DaveBednarcik@westernunion.com Sent by: domino400-admin@midrange.com 04/17/2002 08:24 AM Please respond to domino400 To: domino400@midrange.com cc: Fax to: Subject: Script Error I am seeing this error message when I am trying to insert a record on DB2 file via Lotus Script: 04/17/2002 09:08:52 AM Addin: Agent 'Create Stat' error message: Error: See SQL7008 for invalid state possibilities. This error is most common when the table is not journaled and no indication Does anyone know how I can indiacte that the file is not Journaled in Lotus Script. THanks, Dave Bednarcik Email: DaveBednarcik@WesternUnion.com Work #: (201)263-5186 Fax # : (201)263-5455 _______________________________________________ This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list To post a message email: DOMINO400@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/domino400 or email: DOMINO400-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/domino400. _______________________________________________ This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list To post a message email: DOMINO400@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/domino400 or email: DOMINO400-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/domino400. _______________________________________________ This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list To post a message email: DOMINO400@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/domino400 or email: DOMINO400-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/domino400. _______________________________________________ This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list To post a message email: DOMINO400@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/domino400 or email: DOMINO400-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/domino400. _______________________________________________ This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list To post a message email: DOMINO400@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/domino400 or email: DOMINO400-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/domino400.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
