Attachments on PO's and Orders

We had seen similar things (we are also SQL server) only ours were on quote and part attachments. Seems to have something to do when drawings are stored on a server where users may or may not have access (permissions to read/write) or, if the drawing is renamed on the server and the file path is not changed on the attachment after the file is renamed

Chad Corkrum <chadcorkrum@...> wrote: Has anyone run into the following error in 8.03.305J we just migrated to 8.03 from 8.0 and have found a hand full of PO's and Orders that seem to have attachments that no longer come up. (we are also on sql 2005)

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Table: POHeaderAttch

Company='LSF' PONum='66411' DrawingSeq='1' RowIdent='0x003904a500010000574845524520282850524f47524553535f5245434944203d200000002a0004000400000000000000000000086229292000': Column 'Company, PONum, DrawingSeq' is constrained to be unique. Value 'LSF, 66411, 1' is already present.

Company='LSF' PONum='66411' DrawingSeq='1' RowIdent='0x003904a500010000574845524520282850524f47524553535f5245434944203d200000002a0004000400000000000000000000092529292000': Column 'Company, PONum, DrawingSeq' is constrained to be unique. Value 'LSF, 66411, 1' is already present.

Unable to locate table in data dictionary viewer.
Event Summary: Called customer
Event Details:
LVM to see if they are progress or SQL in order to

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]





__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]
Has anyone run into the following error in 8.03.305J we just migrated to 8.03 from 8.0 and have found a hand full of PO's and Orders that seem to have attachments that no longer come up. (we are also on sql 2005)

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Table: POHeaderAttch

Company='LSF' PONum='66411' DrawingSeq='1' RowIdent='0x003904a500010000574845524520282850524f47524553535f5245434944203d200000002a0004000400000000000000000000086229292000': Column 'Company, PONum, DrawingSeq' is constrained to be unique. Value 'LSF, 66411, 1' is already present.

Company='LSF' PONum='66411' DrawingSeq='1' RowIdent='0x003904a500010000574845524520282850524f47524553535f5245434944203d200000002a0004000400000000000000000000092529292000': Column 'Company, PONum, DrawingSeq' is constrained to be unique. Value 'LSF, 66411, 1' is already present.

Unable to locate table in data dictionary viewer.
Event Summary: Called customer
Event Details:
LVM to see if they are progress or SQL in order to

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]