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.





This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].