Good Day Tanya:
I am not sure I understand but if it is an empty database, then
it would not find any records, or all the fields are Null.
Another thought: With Logic fields (Y\N), I never know if the
filter is Y or YES or T or True, F, etc. Any chance you just have the
wrong parameter? Although you said you tried "ALL". I am not that
familiar with Logic fields, but "ALL" would not be an allowable value???
- no record would have "ALL" in a field; but There could be programming
that would make "ALL" allowable - I just do not know enough.
Len
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tanya Denison
Sent: Thursday, November 15, 2012 9:54 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Quick Search error
Thanks for the ideas, Len. However, I see this in an empty database as
well.
The error says:
Failed to enable constraints. One or more rows contain values violating
non-null, unique, or foreign-key constraints.
Which is particularly odd, getting this with the empty database.
*Tanya Denison* | IT Manager | NRS, Inc.
*2009 S. Main Street, Moscow, ID 83843*
*tdenison@... *|* www.nrsweb.com*
*c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*
*From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] *On
Behalf Of *Len Hartka
*Sent:* Thursday, November 15, 2012 5:49 AM
*To:* vantage@yahoogroups.com
*Subject:* RE: [Vantage] Quick Search error
Good Day Tanya:
Your screen shots did not come through, so you will need to type in the
error.
Some wild guesses:
1. "All" results in too many records so it locks up. Use another filter
( date range?) to limit it somehow to a few records.
2. Maybe you need an outer join - if a child table does not have the
record, and you filter on a field in the child table, it might act odd.
3. Are any of the tables aggregated ( SUM shows in the file box on the
first screen).
4. Are some of the records Null in a Yes\no field - I think it should
still work, but nulls are always a potential problem.
len.hartka@...
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tanya Denison
Sent: Wednesday, November 14, 2012 11:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Quick Search error
I had developed a quick search based on the zOrderLines quick search.
Part
of this was adding two yes/no/all fields. The two new fields worked
great for a few days. But yesterday after no changes, I suddenly got
this error. Today I found that some users reported seeing the same
error, but other users had no problems in the same database.
[image: qserr.JPG]
If I remove the yes/no/all criteria from the quick search, they work
fine.
If the user selects a value instead of All, they work fine. I can run
Analyze in the BAQ with no criteria and the results come back with no
errors.
The two yes/no/all fields are set up with value lists like so:
[image: qscrit.JPG]
Has anyone seen this behavior before? We are on 9.05.605 with SQL Server
64-bit
*Tanya Denison* | IT Manager | NRS, Inc.
*2009 S. Main Street, Moscow, ID 83843*
*tdenison@...
<mailto:%2Atdenison%40nrsweb.com<%2Atdenison%40nrsweb.com>>
*|*
www.nrsweb.com*
*c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*
[Non-text portions of this message have been removed]
This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
I am not sure I understand but if it is an empty database, then
it would not find any records, or all the fields are Null.
Another thought: With Logic fields (Y\N), I never know if the
filter is Y or YES or T or True, F, etc. Any chance you just have the
wrong parameter? Although you said you tried "ALL". I am not that
familiar with Logic fields, but "ALL" would not be an allowable value???
- no record would have "ALL" in a field; but There could be programming
that would make "ALL" allowable - I just do not know enough.
Len
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tanya Denison
Sent: Thursday, November 15, 2012 9:54 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Quick Search error
Thanks for the ideas, Len. However, I see this in an empty database as
well.
The error says:
Failed to enable constraints. One or more rows contain values violating
non-null, unique, or foreign-key constraints.
Which is particularly odd, getting this with the empty database.
*Tanya Denison* | IT Manager | NRS, Inc.
*2009 S. Main Street, Moscow, ID 83843*
*tdenison@... *|* www.nrsweb.com*
*c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*
*From:* vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] *On
Behalf Of *Len Hartka
*Sent:* Thursday, November 15, 2012 5:49 AM
*To:* vantage@yahoogroups.com
*Subject:* RE: [Vantage] Quick Search error
Good Day Tanya:
Your screen shots did not come through, so you will need to type in the
error.
Some wild guesses:
1. "All" results in too many records so it locks up. Use another filter
( date range?) to limit it somehow to a few records.
2. Maybe you need an outer join - if a child table does not have the
record, and you filter on a field in the child table, it might act odd.
3. Are any of the tables aggregated ( SUM shows in the file box on the
first screen).
4. Are some of the records Null in a Yes\no field - I think it should
still work, but nulls are always a potential problem.
len.hartka@...
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tanya Denison
Sent: Wednesday, November 14, 2012 11:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Quick Search error
I had developed a quick search based on the zOrderLines quick search.
Part
of this was adding two yes/no/all fields. The two new fields worked
great for a few days. But yesterday after no changes, I suddenly got
this error. Today I found that some users reported seeing the same
error, but other users had no problems in the same database.
[image: qserr.JPG]
If I remove the yes/no/all criteria from the quick search, they work
fine.
If the user selects a value instead of All, they work fine. I can run
Analyze in the BAQ with no criteria and the results come back with no
errors.
The two yes/no/all fields are set up with value lists like so:
[image: qscrit.JPG]
Has anyone seen this behavior before? We are on 9.05.605 with SQL Server
64-bit
*Tanya Denison* | IT Manager | NRS, Inc.
*2009 S. Main Street, Moscow, ID 83843*
*tdenison@...
<mailto:%2Atdenison%40nrsweb.com<%2Atdenison%40nrsweb.com>>
*|*
www.nrsweb.com*
*c: 208.301.0599* | *p: 208.883.7834 Ext 277 *|* f: 208.882.1744*
[Non-text portions of this message have been removed]
This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.