When I uncheck 'Verifiy uniqueness of WBS Code', then close and reopen the WBS definition, the 'Verifiy uniqueness of WBS Code' box is re-checked. Anyone know how to make it stay UN-checked? This worked in previous versions of MSP. I'm using MSP 2010
SP1.

Hi Jill,
Just jump in to say, you cancontact Microsoft Product Support Service department directly or call the specific number for Bug Report.
http://support.microsoft.com/gp/contactbug
Microsoft Customer Service is available Monday through Friday, from 6:30 A.M. to 5:30 P.M. Pacific time. To contact Microsoft Customer Service, please call (800) 426-9400.

For bug report, there is no charge to contact Microsoft Customer Service. After we identify the bug report, your charge will be refunded.

Hi, friends,
When I commit the form for save the record, there is rise an error----FRM-40506: Oracle error: unable to check for record uniqueness.
And I tried to insert exactly the same row data into that table as same db user via TOAD - which worked perfectly.
so what could be forms' problem here ?? and how to solve it ??

Thanks,
Paul

when the table has no primary key.... how do you want to update a specific row ?

The uniqueness is more important for our project.
BTW, is there other functions like this one : SYS_GUID ?

But the maintenance developers will. And will curse you and your descendants to the tenth generation. Trust me. I've been there.We have all been there. I already curse the former developer of our projects... to the first generation only :p
I have left some nice comments in the for the tricky parts of the code anyway.

hello all,
I want to have uniqueness for uidnumber and gidnumber in my DS so I created 2 more plug in instances. The plug in for uid is already enabled. When I added them i got this
[07/Jan/2004:17:04:38 +0200] - ERROR33040 - Attribute Uniqueness Plugin - conn=8292832 op=1 msgId=2 - ADD parameter untagged: uid

According to the manual this error code it is Configuration error and I have to check the dse.ldif file for the syntax and values.
I read the dse.ldif but I did n't see and I could understand if there is any problem
I made a few tests and the plugins are working, I tried to add group and users with same uidnumber or gidnumber and I couldn't and in the errors log I saw that the plugin did n't allow the
creattion of the entry.

Any ideas about this?

Regards,
Pavlos

dn: cn=slbgidnumber uniqueness,cn=plugins,cn=config
changetype: add
objectClass: top
objectClass: nsSlapdPlugin
objectClass: ds-signedPlugin
objectClass: extensibleObject
cn: slbgidnumber uniqueness
nsslapd-pluginPath: /usr/opt/sunone/ds5.2/lib/uid-plugin.so
nsslapd-pluginInitfunc: NSUniqueAttr_Init
nsslapd-pluginType: preoperation
nsslapd-pluginarg0: gidnumber
nsslapd-pluginarg1: ou=group, o=myzone.gr
nsslapd-plugin-depends-on-type: database
nsslapd-pluginEnabled: on
nsslapd-pluginId: NSUniqueAttr
nsslapd-pluginVersion: 5.2
nsslapd-pluginVendor: Sun Microsystems, Inc.
nsslapd-pluginDescription: Enforce gidnumber unique attribute values
ds-pluginDigest:: 02Q7yVLYsC8FInPrvbAKYq7Rj0o=
ds-pluginSignature:: MIIBjwYJKoZIhvcNAQcCoIIBgDCCAXwCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHATGCAVswggFXAgEBMFYwTTELMAkGA1UEBhMCVVMxGTAXBgNVBAoTEFN1biBNaWNyb3N5c3RlbXMxIzAhBgNVBAMTGlBsdWdpbiBTaWduaW5nIENlcnRpZmljYXRlAgUA5X1ATjAJBgUrDgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDMwNTIzMDIxMDE5WjAjBgkqhkiG9w0BCQQxFgQUK++U3uA/HWIl0Qp4mp+nKPuV/B0wDQYJKoZIhvcNAQEBBQAEgYB+BTTCfaaDp0mBVlaqenvMjY9Q9F5H2lt6zonM9tqwaoUT8aI8wLFWWjyaFZ49PmGoU5fVNZPpuCf/9IT/FI9rzC+egCH4NQ33hqFHLIRfmaLWwT4cc6UrSQKGgQCF7bNg2cP6S718PbiG4rPGq8G9K+dxeeWkLkDy2g9sSACg6Q==

dn: cn=slbuidnumber uniqueness,cn=plugins,cn=config
changetype: add
objectClass: top
objectClass: nsSlapdPlugin
objectClass: ds-signedPlugin
objectClass: extensibleObject
cn: slbuidnumber uniqueness
nsslapd-pluginPath: /usr/opt/sunone/ds5.2/lib/uid-plugin.so
nsslapd-pluginInitfunc: NSUniqueAttr_Init
nsslapd-pluginType: preoperation
nsslapd-pluginarg0: uidnumber
nsslapd-pluginarg1: ou=users, o=myzone.gr
nsslapd-plugin-depends-on-type: database
nsslapd-pluginEnabled: on
nsslapd-pluginId: NSUniqueAttr
nsslapd-pluginVersion: 5.2
nsslapd-pluginVendor: Sun Microsystems, Inc.
nsslapd-pluginDescription: Enforce uidnumber unique attribute values
ds-pluginDigest:: 02Q7yVLYsC8FInPrvbAKYq7Rj0o=
ds-pluginSignature:: MIIBjwYJKoZIhvcNAQcCoIIBgDCCAXwCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHATGCAVswggFXAgEBMFYwTTELMAkGA1UEBhMCVVMxGTAXBgNVBAoTEFN1biBNaWNyb3N5c3RlbXMxIzAhBgNVBAMTGlBsdWdpbiBTaWduaW5nIENlcnRpZmljYXRlAgUA5X1ATjAJBgUrDgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDMwNTIzMDIxMDE5WjAjBgkqhkiG9w0BCQQxFgQUK++U3uA/HWIl0Qp4mp+nKPuV/B0wDQYJKoZIhvcNAQEBBQAEgYB+BTTCfaaDp0mBVlaqenvMjY9Q9F5H2lt6zonM9tqwaoUT8aI8wLFWWjyaFZ49PmGoU5fVNZPpuCf/9IT/FI9rzC+egCH4NQ33hqFHLIRfmaLWwT4cc6UrSQKGgQCF7bNg2cP6S718PbiG4rPGq8G9K+dxeeWkLkDy2g9sSACg6Q=

Hi,
could it be that the server cares about lower/uppercase values in this case (I don't know), I would try to add the plugins using the exact cases (uidNumber instead of uidnumber, gidNumber instead of gidNumber) - I hadn't any problems doing so on DS5.2 and DS6.
Regards
Jochem Ippers

I am performing import of flat files to a data repository database.
In order to determine whether to update or insert, I need to have uniqueness of the table AP_HOLDS_ALL.
Oracle suggested the concatenation of the columns INVOICE_ID, LINE_LOCATION_ID and HOLD_LOOKUP_CODE for practical purposes.
Does anyone know whether there are any other combinations of columns to obtain uniqueness of the table, please?

I am performing import of flat files to a data repository database.
In order to determine whether to update or insert, I need to have uniqueness of the table AP_HOLDS_ALL.
Oracle suggested the concatenation of the columns INVOICE_ID, LINE_LOCATION_ID and HOLD_LOOKUP_CODE for practical purposes.
Does anyone know whether there are any other combinations of columns to obtain uniqueness of the table, please?

I'm trying to change the naming attribute from cn to uid to maintain uniqueness in the dn.

For example, I want the dn to appear as:
dn:uid=xxxxxxxx,o=my-company,c=us

instead of:
dn:cn=xxxxxxxx,o=my-company,c=us

How do I do this? Any help appreciated.

After playing around a bit, I figured out how to do this...

* Login to http://host:port/identity/oblix/
* Go to Identity System Console -- User Manager Configuration -- Tabs -- Employees -- Modify Attributes
* Select the cn attribute and de-select DN prefix under Semantic type, click Save
* Select the uid attribute and select DN prefix under Semantic type, click Save
* Click done

Be sure to specify a new ou (or cn or whatever...) as the target or modify the dn of existing entries in the current ou (or cn...)

Hi,
I have read a couple of forum threads on the topic but I still don't know how to solve this in elegant way.

I remember one post referring to calculation checking for uniqueness during IAF (Extension DLL) and I liked the idea.
It was suggested to check for uniqueness in MV. But wasn't actually describing the way to accomplish that, I was able to do this using a SQL query, but I'm not sure if this is correct. It seems to work correctly, but I'm not sure of consequences it may have.

So the import flow from SQL table to MV would look: if the attribute value (to be generated) in MV is empty, and then generate the value using a pretty simple algorithm (concatenating 2 existing attributes) and checking in MV for uniqueness (SQL Query).

I was also considering using a portal workflow to generate the attribute values but it seems to me even more problematic as a lot of workflows run at the same time so it may not guarantee the uniqueness at all.

I would be thankful for any suggestions and comments.
Bart

Indeed this would substitute my SQL query to MV mms_metaverse table. Thanks, this was really quick and helpful !

Actually looked in the SQL profiler what query is being executed by the FindMVEntries and it seems that it's exactly the same query I was running myself, however, in a probably more supported way.

select*
fromdba_cons_columns
whereowner = 'ANDY'
and table_name = 'TEST_TABLE'
/
selectowner
,index_name
,table_name
uniqueness
fromdba_indexes
whereowner = 'ANDY'
andtable_name = 'TEST_TABLE'
/reference;http://www.shutdownabort.com/dbaviews/dba_cons_columns.php

Hi Kiran,
I have used the query you gave, yes I see the Primary key on each table, there are no referential integrity's on this database. for example i have 4 tables say table A, table B, table C, Table D and each table have PKs on more than 2 columns such as on Table A i have code1, code2, where as ob table B code1, code2, refcode1 ect...how do i know which is parent and which is child table? any other way to find out other than querying each and every table?

Thnaks for your help.

Hi all,

since JCR handles the MULTIPLE node propries as an array of Value an application has to hande the uniqueness of the values by itself. E.g. throgh Set. But org.modeshape.graph.property.Reference does not implement hashCode() method.

Does anybody have any other ideas how to handle the value's uniqueness in a MULTIPLE node property?

Dmitri included this in MODE-1092.

Hi John. Thanks for responding. I guess this is why I have been avoiding using the 'allow duplicates' function until now. I'm not a fan of it either. In this customer's case, we have need of allowing duplicate aliases. I am forcing uniqueness on member names by using prefixes in all dimensions.

They have a few dimensions that have country names for aliases. They want (need) them to be straight country names.

For now, I have turned off 'allow duplicates' on the one dimension that has three hierarchies because there isn't a need for it there. So, I may have found my work around for the time being. I would prefer to learn how to do this function for future reference.

Thanks

I spent some time going through this and it seems there is no functionality to do this via a load rule. It looks like you can only do it via EAS. It seems that when the duplicate member functionality was added, load rules were not updated to deal with this. There is a similar issue with ASO where you can't set a couple of properties via load rules. Annoying! I think it stems from the fact that when they built load rules, shared members were not something you could explicitly tag during a load; shared members were implicit based on the fact the member name already existed. I imagine when they first developed it they did not envision duplicate member names and this must be very deep in the code and why they don't fix it (just speculating of course).

Fortunately we have work arounds. For your situation, I would allow the third member that you want to be the shared member, load as a unique member. Set it to dynamic calc with a member formula that references the member you want it to be "Shared" as.

i.e.

KS
--Kansas City (Stored)
MO
--Kansas City (Stored)
Alt Rollup
--Kansas City (Dynamic Calc) [Formula: "[KS].[Kansas City]"; /*pseudo shared member*/

Hi,

Now I am having a scenario in my project.

Suppose I have placed a Purchase Order for 'X' Material for 500 qty. At the time of GRN system generates one batch number for this 500 qty. let us say batch B1 is generated by the system. But my requirement is I have to maintain uniqueness in this batch for every quantity. this uniqueness like B1-1, B1-2, B1-3, B1-4 ..........................B1-500. So that they can trace which material is in which placce and to whom we have sold out. How to maintain this scenario in batch management.

Please don't suggest "use serial number for this scenario". This is not acceptable for my scenario.

Regards,

Venkat

Ph: 9990417848

Suppose I have placed a Purchase Order for 'X' Material for 500 qty. At the time of GRN system generates one batch number for this 500 qty. let us say batch B1 is generated by the system. But my requirement is I have to maintain uniqueness in this batch for every quantity. this uniqueness like B1-1, B1-2, B1-3, B1-4 ..........................B1-500. So that they can trace which material is in which placce and to whom we have sold out. How to maintain this scenario in batch management.

Please don't suggest "use serial number for this scenario". This is not acceptable for my scenario.

You should use serial number management. There's no point in speaking about batch if you give batch number for each pc of your material.

If you want to give a unique ID for each piece of your material, your "batch" is called serial number...

batch - Longman dictionary:

quantity of food, medicine etc that is produced or prepared at the same time

batch - SAP glossary:

Subset of the total quantity of a material held in stock, which is managed separately from other subsets of the same material.

Examples: different production lots (such as paints, dyes, wallpapers, and pharmaceutical products), delivery lots, quality grades of a material.

serial number - Longman dictionary

a number put on things that are produced in large quantities, so that each one has its own different number:

serial number - SAP glossary

Number that you give to an individual item of material in addition to the material number, in order to differentiate that individual item from all the other items of the material.

The combination of material and serial number is unique.

So, I think you should give the reason why you don't want to use SAP standard solution...and you should justify your requirement because you seem to be against the meaning of batch serial number....

Regards,

Csaba

Edited by: Csaba Szommer on Apr 5, 2009 6:52 PM

Edited by: Csaba Szommer on Apr 5, 2009 6:54 PM

Hi,

I need to store an undirected graph.
Supposed I have 2 tables for storing node and edges.

How to enforce uniqueness of each node pair in edges table, as in:

If below pair already exists in database
node1: a
node2: b

Then user should not be able to insert/update pair of
node1: b
node2: a

Please help.

TIA.

Thank you all for the answer.
For my case, the nodes should not be null

I have the UID Uniqueness enabled in a multi-master environment. Yes I've read the plugin is not designed for multi-master replication environments and that if the UID is modified on more than one server at the same time the plug-in cannot detect it because it does not perform the uniqueness check when receiving replication updates, but only on the master in which the update is being made.

That being said, the risk I run is that I unknowingly have duplicate UIDs in my system that were not detected. However, what I have recently been experiencing is the UID uniqueness plugin being tripped with false positives. Periodically, maybe once per week, or 0.5% of update transactions, an update to the directory will return err=19, tag=105 with the error log stating Attribute Uniqueness as the problem. In each case, simply re-running the LDAP modify yeilds success. Basically the UID uniqueness plugin is reporting a false positive.

The UID is not the naming attribute in our system but is configured identically (applicable subtrees) on each of the servers.

Is there a known scenerio where this can occur? Am I wasting my time having the plugin enabled on each master?

DS 5.2_4 pkg install
Solaris 9

Thanks

does your system reuse ids? could the system be seeing an entry marked for deletion, and still holds the unique uid value, only when the object is really finally deleted do you see it work, appearing like a false positive?
I forget how to find a deleted entry, but it assigns it a new objectclass and does a modrdn to a guid value, then deletes the entry later. Just a thought.

I'm using WDS to deploy an automated build of WinXP Pro.  I've gotten everything to work with one exception.  I want to use Uniqueness Database files to hand out different product keys to different machines.  Has anyone used UDF's for product keys?  If so, can you provide a functional example?  (I don't expect a functioning key :))Thanks!---Devin

Hi Devin,
 
Hope these can help:
 
http://technet.microsoft.com/es-mx/library/cc722944(en-us).aspx
http://technet.microsoft.com/es-mx/library/cc749979(en-us).aspx
 
Tim Quan - MSFT
 

I would like to check for uniqueness of the mailnickname attribute on group creation, but i would also like to check against the person object as well.
I tried adding both:

my:Property
my:Name=UniquenessValidationXPath
my:Value=/Person[MailNickname='%VALUE%']
/

my:Property
my:Name=UniquenessValidationXPath
my:Value=/Group[MailNickname='%VALUE%']
/

but it only validates the first one, and ignores the second.
Is there a way to do this all on one line, like

my:Property
my:Name=UniquenessValidationXPath
my:Value=/Person[MailNickname='%VALUE%']
or /Group[MailNickname='%VALUE%']
/
Thanks

Thanks Henrik! You are the man!

Hi, I would like to run Uniqueness profiling on my db but not on single column. My primary keys consist of 3-4 columns. Can I combine those primary keys and then run uniqueness i.e. can I combine multiple columns from a table and then run Uniqueness profiling.

Thanks

Uniqueness is tied to a single column.

The Views inside of IS doesn't appear to allow you to concatenate fields. One thing that you might do is create a View in the database itself where you combine these fields and then profile that view inside of Data Insight.

Hope this is helpful,

Paula

Attribute uniqueness plugin only ensure uniqueness on a single master before the entry is added. It doesn't check replicated operation since they have already been accepted and a positive result was returned to the client. So in a multiMastered environment, it is still possible to add 2 identical attributes, if like you're saying you're adding the entries at the same time on both master servers.

We're working on a solution to have Attribute Uniqueness working in a multiMastered environment. But we're worried about its impact on performances we may get with it.

Regards,

Ludovic.

Hi,

I'm trying to use attribute uniqueness in a iDS 5.1 multi-master replication env. I have created a plug-in instance for the attribute (memberID) on each directory instance (same installation on NT) and tested (if I try to create a duplicate value under the same instance I get a constraint error as expected). However if I create a entry under one instance and then create a second entry (different DN) with the same attribute value on the second instance, the entry is written with no complaints? If I create the entries with an identical DN, then the directory automatically adds nsuniqueID to the RDN of the second entry to maintain DN uniqueness but it doesn't seem to mind about duplicate values within the entry despite the plug-in?

BTW I've tested MMR and it is working and I'm using a subtree to enforce uniqueness.

Regards

Simon

Hi All,

I have an Item of a block, that hast to be unique.
My intention is do check uniqeness when user tries to leave the Item and if not to prevent him from leaving.

How can I realize it
thanks for help
Silke

It is again time to bring up Kevin D Clarke's magic method of testing for uniqueness.

The method he describes works perfectly:

Re: Trigger

Hi! I'm getting noizy error in alert log from time to time:

-----
Join columns of outer join with table table_name have no uniqueness constraints
-----

I've collected all the queries (v$sql, all_source) with montioned table, but non of them produces that error if executed.
Any hints how to reproduce this error or where else to search that buggy sql join?

Edited by: user545083 on 25.10.2010 6:21

Hi

I think this error is output via an materialized view refresh - check for mviews against the given table which fulfil the issue given in the error text.

Thanks
Paul

Your change in code is doing correct. I just wanted to know the logic change which you did.I am just concerned for uniqueness of ASCII values in the long run when data grows.

I have to generate incremental data records in PL SQL.

My logic is, store for each row the ASCII value of concatenated columns in that row.

So if in the future, for generating incremental data (generate data only in case if there is any modification), if any change in the record, the ASCII value will be different and on comparing the ASCII values of new and old records, I can generate only the incremental data.
Well it doesn't make much sense to add a new column and do all that work when you have to compare every column anyway.Just compare the new data column by column with the old data. There must be SOMETHING you can use for a primary key. If the new key doesn't exist it is a new row so just insert it.If the new key exists then do the column by column comparison to determine which columns changed.

Hi all,

I am loading 2LIS_02_ITM (Purchasing Document - Item Level) data to a write optimized DSO. I am still checking uniqueness of data. I am getting duplicate data record errors; however, the records don't appear to be duplicates because the difference is that the Reversal Indicator is checked (X) on some of the records that are failing. Why isn't this recognized?

Any suggestions for eliminating these errors with a write optimized DSO? What are the implications of checking the "do not check for uniqueness" option? I am afraid I will lose records - I need all invoice goods receipt relevant records to be maintained.

Thanks

C

Please see

http://wiki.sdn.sap.com/wiki/display/BI/WriteOptimizedDSO

it might help you

hi all,
I want to develope one application which shall check the uniqueness of the application. I mean to say if I am building a project in VS and creating a exe/dll and some other person is building the same project in VS. Then how we can verify that both executables
or dlls which got created by two person are same.
Is there any way to do this...?
Thanks in advance,
IamHuM

Hi,
Explain how to validate two applications using an automated test suite!? when the applications might not be testable!!?
I'd need to write a book! Eh... two books!!. Have a look at a tool called NUnit. This is a testing framework that can be used to test applications. Problem you've got is the application you have is legacy (using the term from the point of viem that legacy
is code that has no tests) ... and not designed to be testable.
Well ok it's not ideal .... look at NUnit and read up on integration testing, your going to have to test large sections of your code base at a time. That means your going to have a difficult time setting up context for the test.

Actually you know what might help forget NUnit, look into Pex. This is an experimental tool that will generate test code for you, it uses MsTest, Microsofts NUnit clone. That might do a lot for you. Used it once as an experiment.
Best I can do for now, need to be somewhere.

…we each have more potential than we might ever presume to guess. (Blog: http://dsmyth.blogspot.com/)

No, it doesn't always need to be a number.If
the rows naturally have some uniqueness in them,
there is no need to create yet another numericcolumn
to serve as the primary key.It's safer to have a meaningless key, whether numeric
or not. It's more resistent to future change than
relying on the natural uniqueness of your data.So you'd suggest always having doing that? I certainly wouldn't, and would argue that there are TONS of existing corporate tables out there and new ones created every day that don't. Simple case - a table of US states, where the key is the state abbreviation. No need to create some additional meaningless column to serve as the key.

I'm just saying I'm sure there are lots of cases
where tables have natural keys so they don't
need an additional made-up surrogate key added. It
would be a mistake to say you should always
create a surrogate key.Eh. There is never a time that I know of when an artificial key can be harmful, and I don't know of any benefits to natural keys. OTOH, there are times when one thinks a natural key will be fine but later that turns out to be wrong. So I would say it really is a good idea to always use a meaningless key. My 2 cents.

Hi,

I can use testUser to check if an new accountId is unique:

isnull
invoke name='testUser' class='com.waveset.ui.FormUtil'
refcontext/ref
refmyId/ref
/invoke
/isnull

Is there something simular to check the uniqueness of a new mailaddress?

I need to check the waveset.email attribute for this because we don't allow re-using a mailaddress for some time after the user's resource accounts are deleted.

Greetings,
Marijke

This should help you:

http://forums.sun.com/thread.jspa?threadID=5342476

Hashtables, just like arrays ( are expected to ) grow once you exceed the
initial (setup) size. The size that is specified at the creation time is
only the initial size. When you add more elements than what it can
accomodate, the effective size of the hashtable is increased by making one
(or more ) of the bucket pointers to point to sub-tables/arrays.

Eventhough the rearrangement is transparent to the programmer, you should
note that the performance of the look-up algorithm might reduce slightly
with each "growth".

Forte technote 10971 ( LargeArrays, and Hash Tables )nicely explains how
these data structures are managed.

Hope this helps,
Ajith Kallambella M.

From: "Braja Chattaraj" forte_brajachotmail.com
To: forte-userslists.xpedior.com
Subject: (forte-users) Max size of a hash table.
Date: Tue, 20 Mar 2001 12:05:45 -0500

We are trying a performance test and have discovered that the hash table
data structure has a max limit of 32767. The setup() method would not take
anything more than 32767 for the size parameter. The documentation does not
say anything about a max limit for a hash table. Evidently it is using a
signed integer of 2 bytes for the size.

We have been using the hash table to check for the uniqueness of a large
data set of 100,000 ids (rather than looping through the set for each id).
Any duplicates raise an exception which is trapped to validate the
duplicates. We could probably set the size of the hash table to 32767 if we
are sampling more than that many ids but I am not sure about the
performance
if we do so. Will try though

Any comments, suggestions or insight will be appreciated.

Thanks,
Braja.

--
For the archives, go to: http://lists.xpedior.com/forte-users and use
the login: forte and the password: archive. To unsubscribe, send in a new
email the word: 'Unsubscribe' to: forte-users-requestlists.xpedior.com

We had to build a new hash table that linked multiple hash tables together.
I think it was really short sighted of Forte to set that kind of upper
limit. Good luck.

Hi We have a requirement where , On creation page of for "dm_document" object we are checking the value for Customer Id attribute should be unique which is entered by user , So how to incorporate D2 Uniqueness Configuration with the above mentioned condition . Regards Mayur Mitkari

Hi

My DQL Qualification is : "dm_cabinet where object_name='$value(object_name)'"

I am getting following messages in Application logs

""[INFO ] - c.e.d.d.a.s.p.D2SavePropertiesService : Object ID = 0c00afc8800c05b4

"" [DEBUG] - c.e.d.a.c.documentset.D2DocumentSet : "Custom Cabinet" document set for 0c00afc8800c05b4 object and 67Admin user and null interface is true (0.000s)

"" [DEBUG] - c.e.d.a.c.d.D2DocumentSetSwitch : Used "[Custom Cabinet Check]" (d2_uniqueness_config) for 0c00afc8800c05b4 object and 67Admin user (0.031s)

"" [DEBUG] - c.e.d.a.c.m.u.D2UniquenessConfig : retrieving qualification at position 0

"" [DEBUG] - c.e.d.a.c.m.u.D2UniquenessConfig : Qualification to check : dm_cabinet where object_name ='$value(object_name)'

"" [DEBUG] - c.e.d.a.c.m.u.D2UniquenessConfig : Qualification with customized predicate : dm_cabinet where i_chronicle_id '$value(i_chronicle_id)' and (object_name ='$value(object_name)')

""- c.e.d.a.c.m.u.D2UniquenessConfig : Resolved qualification : dm_cabinet where i_chronicle_id '0c00afc8800c05b4' and (object_name ='pol')

emc.d2fs.dctm.api.services.D2Service : D2SavePropertiesService - null
2014-09-29 09:09:37 [ERROR] - c.emc.d2fs.dctm.api.services.D2Service : {}

After this it is taking long time and throwing time out exception.

Regards

Hi,In the release notes I'm reading the following:
Portal User Interface
·    You can now copy and paste a vertical list from Excel to the Resource Picker input box. This is especially useful for doing bulk Adds.
·    The UOC text box now lets you check uniqueness using a custom XPATH statement that you provide.

Note

Hi, It appears to work but it does not work correctly. You cannot use the same XPATH validation filter from the CREATE mode in the EDIT mode. The XPATH validation filter has to be slightly different!
See:
http://blogs.dirteam.com/blogs/jorge/archive/2011/01/23/checking-uniqueness-of-an-attribute-in-fim-2010-during-the-edit-process.aspx
Cheers,
(HOPEFULLY THIS INFORMATION HELPS YOU!)
Ing. Jorge de Almeida Pinto
Senior Technical Consultant
MVP Identity Access - Directory Services
http://blogs.dirteam.com/blogs/jorge/default.aspx
* This posting is provided AS IS with no warranties and confers no rights!
* Always test before implementing!

Jorge de Almeida Pinto [MVP-DS] (http://blogs.dirteam.com/blogs/jorge/default.aspx)

Hi all,

I have a very simple data structure which has

- the key (String) of another data class
- a Date (using TemporalType.DATE)
- an integer value

but the combination of the timestamp and the key makes for a unique identifier. I could quite easily add an additional 4th @Column into my @Entity that is my @Id, but I'd rather investigate how JPA can help me setup a custom @Id that is the combination of the key and the timestamp value. It would be good to be able to let the database manage the uniqueness, instead of me having to programmatically handle (and check) it in JPA-QL queries.

Is this a classic case of @EmbeddedId or @IdClass? If so, it seems like an awful lot of boilerplate code to achieve what I want. Is what I am proposing even recommended? Is there perhaps another way to achieve uniqueness for the combination of these two columns?

In general I would recommend using a generated Id, but yes, your example is a case for using an @EmbeddedId or @IdClass.

See,
http://en.wikibooks.org/wiki/Java_Persistence/Identity_and_Sequencing#Composite_Primary_Keys

-- James : http://www.eclipselink.org

I would like to know how the session id is constructed and how
uniqueness within the id is maintained.

Thanks in advance.

Jacob Waddles

I would like to know how the session id is constructed and how
uniqueness within the id is maintained.

Thanks in advance.

Jacob Waddles

Hello people,

can somebody explain to me, what the hell am I missing?

What enforces the unique value when you create primary or a unique key? I thought it's a unique index, but that turned out to be wrong....

create table test1 (no number primary key);

select index_name,uniqueness
from user_indexes
where table_name ='TEST1';

INDEX_NAME UNIQUENESS
------------------------------ ----------
SYS_C0017897 UNIQUE
/

OK, this works. Exactly as one would expect. But, If I create a table without primary key, create a nonunique index on it and then add the primary key, the index doesn't change.

create table test2 (no number);

create index test2_idx on test2(no);

alter table test2
add constraint test2_pk primary key (no);

select index_name,uniqueness
from user_indexes
where table_name ='TEST2';

INDEX_NAME UNIQUENESS
------------------------------ ----------
TEST2_IDX NONUNIQUE
/

insert into test2 values(1); this goes ok
insert into test2 values(1); and here I get an error

So, it doesn't allow duplicate values...well, that's good

When I queried the index above it shows that it's nonunique.
So, I came to conclusion that I don't need it anymore and decided to drop it.

drop index TEST2_IDX ;

and I got

ORA-02429: cannot drop index used for enforcement of unique/primary key

So, I' have a nonunique index that is enforcing uniqueness on primary key. And I have a headache, because I don't understand what's going on.

Same thing would happen if I created a column, then created a nonunique index on it and finally added a nonunique constraint.

The index would still be NONUNIQUE.

I was coming to conclusion that it's not the index that is preforming the uniqueness check, so I tested the following - create a column with unique index without unique key.

create table test3(no number);
create unique index test3_idx on test3(no);
insert into test3 values(1);
insert into test3 values(1); - error

ORA-00001: unique constraint (TEST.TEST3_IDX) violated
00001. 00000 - "unique constraint (%s.%s) violated"

So index is enforcing it.

Can somebody please tell me, what am I missing? I came to conclusion that Oracle sometimes doesn't care if index is unique or not.

sybrand_b wrote:
The mechanism is version dependent. Obviously you assume everyone is using the same version and/or Oracle never changes, so that is why typing 4 digits and three dots is too cumbersome for you.
The other part of the issue is this is a documented feature: an primary key can be enforced by a non-unique index.
Apparently you don't -like 99.999 percent of all people asking questions here - read documentation.
As you don't provide a version I sadly can't provide a link.
I recommend before you start wasting your time by setting up testcases and posting them here you read documentation.

--------------
Sybrand Bakker
Senior Oracle DBAWhat a snotty answer to what was a very reasonable, thought out and politely put question. I hope you didn't get any Helpful points for this.

Seriously, learn some manners.

My application was migrated from Designer 2.1 to Desinger 9i. In Designer 2.1 a table element was attached to a document. After migration the element was missing. When attempting to re-attach the element in Desginer 9i I know receive the below listed error(s). I do not understand the reference to what "documentation" should be refered to. Both the table element and dcoument have been 'checked out'.

Thank you.

------------------------------------------------------------------------------------------

Message
-------
RME-00209: Current activity has outstanding violations

Cause
-----
Could not 'commit' the data because of outstanding
data integrity violations.

Action
------
Examine violations, fix the invalid data, and try again.

------------------------------------------------------------------------------------------

Message
-------
RME-00224: Failed to close activity

Cause
-----
Could not close ('commit') an activity.

Action
------
Examine other reported errors for specific details.

------------------------------------------------------------------------------------------

Message
-------
CDA-01305: Document Attachment: UID 1 uniqueness violation

Cause
-----
A uniqueness constraint violation was detected for this element.

Action
------
Refer to the documentation for the uniqueness constraint rules for
this element. The number after 'UID' refers to which uniqueness
constraint is violated if there are more than one.

------------------------------------------------------------------------------------------

My application was migrated from Designer 2.1 to Desinger 9i. In Designer 2.1 a table element was attached to a document. After migration the element was missing. When attempting to re-attach the element in Desginer 9i I know receive the below listed error(s). I do not understand the reference to what "documentation" should be refered to. Both the table element and dcoument have been 'checked out'.

Thank you.

------------------------------------------------------------------------------------------

Message
-------
RME-00209: Current activity has outstanding violations

Cause
-----
Could not 'commit' the data because of outstanding
data integrity violations.

Action
------
Examine violations, fix the invalid data, and try again.

------------------------------------------------------------------------------------------

Message
-------
RME-00224: Failed to close activity

Cause
-----
Could not close ('commit') an activity.

Action
------
Examine other reported errors for specific details.

------------------------------------------------------------------------------------------

Message
-------
CDA-01305: Document Attachment: UID 1 uniqueness violation

Cause
-----
A uniqueness constraint violation was detected for this element.

Action
------
Refer to the documentation for the uniqueness constraint rules for
this element. The number after 'UID' refers to which uniqueness
constraint is violated if there are more than one.

------------------------------------------------------------------------------------------

Hi all,

I know to eliminate duplicates we can go WDSO or check uniqueness of data---settings --- standard DSO I want to identify /trace duplicates while looking into DSO / Infocube and can i trace out exactly which request has data that duplicated data in the cube/DSO?

can u suggest me?

To identify the duplicate records while loading to a cube,

In the UPDATE tab of the DTP, under Error Handling choose Update Valid Records, No Reporting(Request Red).

If there are any duplicates those will be captured in the error stack. Display Error Stack to see the duplicate records.

Does this help??

Regards,

Meghana

--
Hi everyone,

I'm woring in Form 4.5.
How do I check the record uniqueness within a multiple-record
block in order to display an
error message to the user who have entered the key value twice
in the keyin process
(post_text_item_trigger) rather than firing the on_check_unique
trigger during the commit
operation ?

Any help is appreciated.

Andy
null

--
Andy Yeh (guest) wrote:
: Hi everyone,
: I'm woring in Form 4.5.
: How do I check the record uniqueness within a multiple-record
: block in order to display an
: error message to the user who have entered the key value twice
: in the keyin process
: (post_text_item_trigger) rather than firing the on_check_unique
: trigger during the commit
: operation ?
: Any help is appreciated.
: Andy

Dear Andy
Oracle will raise an error when it commit the record which
contains the duplicate key value.

But we can write a simple select statement in the post-text-
item trigger to avoid the duplicate values.

declare
var_empno emp.empno%type;

begin

select empno into var_empno from emp
where empno = :emp_block.empno;

message ('Already Exists ');

exception
when no_data_found then
null;
end;

In this code let us assume, the emp is the base table, emp_blcok
is the block for emp table, empno is a primary key in that table
and the var_empno is a temporary variable.

When a user type a value in the field and jumps to next filed
this code will fetch the empno from the emp table by matching
the entered empno with table's data.

If the value is not there it will fire exception. In that
exception null is available. So no problem. That means the key
value is not there.

If the key value is already there, it won't fire exception, it
will come to the next statement. That is the message statement.

Using this code you can avoid duplicate key values.

Thanks and Regards

Jeya Raman R

null

Hi,

I have this requirement.In Customer repository I have a tuple for Phone numbers with fields like Phone number, Is Standard No, Notes etc.Everytime I import data in this tuple it would be based on uniqueness of the phone number along with Cust No .

Now I have to change the format of Phone number , how do I import this?

Say for eg Phone number was +1-676-434-9898 Now I want it as 6464349898.

If I re import this , it is treated as new number but I just want to update this?

Regards

Nisha

Hi Nisha,

yes, "Creating a new field and importing values in that and then deleting the original" is one option.

But please also give a try first by reimporting data. Try below steps to solve your issue:

Open import manager and your data map. Change the "Set tuple update" from "Update mapped records" with "Replace". (* I am not sure what matching fields you have defined in Tuple upate option. if needed then please change them as per need)

After changing the tuple update option to replace, import data using updated map and let us know if this solves your problem.

- Shiv

Is it possible to have "same names" Virtual Machines within a datacenter?

So, for example - a vm named "sql1" running on host1 in cluster1 and then a DIFFERENT VM named "sql1" running on, say, host 2 in cluster 2?

Where and how is VM name uniqueness enforced?

the uniqueness is enforced at the vCenter level. All objects have to have a unique name.

Hi,

I've got the 1D array of the DBL values.

How to quickly check all of they are unique?

What happens if you're comparing two NaN entries in a numeric array?

Edit - by which I mean to say that, as usual, altenbach has a pretty good example of this - have a read through the comments here

---CLD

I have separate assets tables for storing different kind of physical and logical assets, such as:-

Vehicle table( ID, model, EngineSize, Drivername, lastMaintenanceDate)Server table ( ID, IP, OSName, etc…)VM (ID, Size, etc…).VM_IP (VM_ID,IP)
Now the problems I have is:-

For the IP column in the server table and in the VM_IP table, I need this column to be unique in these two tables, so for example the database should not allow a server and a VM to have the same IP. In the current design I can only guarantee uniqueness
for the table separately.
So can anyone advice on how I can handle this unique requirement on the databases level.

Regards

Hi,
Create a primary key on 2 fields like ID, IP in server and VM_IP table. So that there is no duplicate records.Balaji -Please click mark as answer if my reply solves your problem.

Hi!

I want to ensure the uniqueness of objects into a vector.

Vector BunchOfFlowers = new Vector();

BunchOfFlowers.add( new Flower("red") );
BunchOfFlowers.add( new Flower("green") );
BunchOfFlowers.add( new Flower("pink") );If I want to add a ...new Flower("red").... is there a smart way to find out that the vector contains already an element which was instanciated in the same way??

Do I have to loop through the vector?

Kind regards

And now, that I am involved in projects ofsignificant size, Eclipse is my friend.

That's cool. But my scorn is directed at the teachers
who take noobies and
teach them to drag'n'drop, and never bother to even
discuss what's really
happening. Programming as magic.Absolutely.... none scorn the premature use of IDEs as much as I

Hi Everybody,
Help me, please
I have problem with unique index.
How to catch the message The uniqueness of primary or candidate key is violated. (Error 1884) in Browse window (or Grid control). Because I want to display my message instead VFP's meassage.
 
I use VFP9.
Sorry because my english is not good!
 
Thanks everybody
 

Hi all (Markish,CetinBasoz),
Thanks in advance for your helps.
I solved my prolem.
I'm sorry, because my english is not enough to say thank to you.
 
Best regards,
Minh Tran

Hi!

We plan to use the sysjobid macro variable as an id for our historical tables to indicate uniqueness of data batches. Is it possible to recur?

Thanks for the help!

I see. Thanks for the help guys, as well as for the tips.

Two ways to do this.


For the simple case like yours you can simply check against each value to see it is unique. If it is not unique then randomize it until a unique value is returned.


The complex case is used with more numbers, or where checking the uniqueness is difficult or time consuming, or if you need to randomise the entire range. Typically you create the entire range of possibilities in a list. Then remove that item from the list once it is created, meaning it can never be selected again.

Two ways to do this.


For the simple case like yours you can simply check against each value to see it is unique. If it is not unique then randomize it until a unique value is returned.


The complex case is used with more numbers, or where checking the uniqueness is difficult or time consuming, or if you need to randomise the entire range. Typically you create the entire range of possibilities in a list. Then remove that item from the list once it is created, meaning it can never be selected again.

Hi Folks
I want to create a request .I want to check if the record already exists or not .If exists,I want to update else i want to create.How to check the uniqueness of this record through a filter ? Kindly help

Thnks in Adv
Priya

Sure...you can key off the request ID. It is not unique to the form, unless you use a prefix and you are certain the prefix isn't used anywhere else. I do enough importing and exporting of records where I choose NOT to use a request ID as my unique key value as it can change. Whereas if you use a GUID (like an instance ID) as your unique field, the value will not change if you happen to import it to another system and generate a new request ID which will then break the link.. Either will work to identify the record. It just depends on how flexible you want to configuration to be.

Hello friends i am trying to define an Inventory org

In the process when i reach Revision,lot,And LPN

Lot Control

uniqueness : trying to select Across Items from the List of Values There come the error message as

APP:INV-05381:Lot numbers exist that have been used for different items

Lot uniqueness will be violated -update not allowed

Can any one find a solution and let me know

Kind Regards
Pru

Hello,

Please check this metalink note.
INVSDOIO: APP-INV-05381 Cannot Change The Parameter Lot Control Uniqueness [ID 1124233.1]

Thanks
-Arif.

Hi All,

Thanks for the reply

For our sequences in Oracle, we not only require the uniqueness but also ordering of sequences.

To give precise example, we are sending the files to other interfaces, we have sent the file XXXX000001.xx to them, and then the next file they are expecting is XXXX000002.xx.

If we are going for CACHE (ex. 1000), then for one instance the sequence increment happen like 1 to 1000 and then might be 2000 to 3000.

We have other scenario in which also we require behavior of number with uniqueness and ordering.

I am reiterating the problem we are facing with these sequences of NOCACHE and ORDER. This has an ORDER and NOCACHE means for every NEXTVAL, it needs to check against all the instances to sychronize itself. We have large no. of transactions which increment sequences.

Please get back to me if you require some other information also.

Regards,
Manoj

For our sequences in Oracle, we not only require the uniqueness but also ordering of
sequences.
This is a violation of relational design. A surrogate key (which is the purpose of a sequence) only guarantees uniqueness - nothing more.

Trying to enforce some kind of physical ordering of rows based on a number, is also missing the fundamentals of server programming, server performance, and server scalability.

"Serialisation kills performance!" (say this phrase repeatedly until enlightenment is achieved)

Heck, even from a business perspective your so-called requirement reeks. Take a business that writes invoices. Typically there will be more than one invoice book in order for more than one salesperson to make out an invoice (serialisation kills performance!). Some invoices can be made out incorrectly and land in the dustbin. Invoice books can be checked out in the wrong chronological order from stationary). Etc.

Numerous factors that can and will ensure that the invoices made out by the business is not made out in a nice ascending numerical order. Not that it ever matters as there is an invoice date.

But your requirement is so special and so unique, that it not only violates relational design and fundamental RDBMS scalability, it is also contrary to every common sense business process flow...? Yeah right.

Hi,I'm have Webtop 5.3 working with 5.2.5 eContent server. In the DocApp Builder, I have defined the various attributes for different tabs that appear in my custom object Properties component. In my custom attribute, I have three attributes (attr_a, attr_b, attr_c), and I need to implement a uniqueness check to make sure that the combination of the three attributes is unique.I'm looking at implementing this in either a custom Properties or custom Attributes class, but I'm not sure how to get the info that the user has entered for those three attributes to run my uniqueness check. I would like to run this check before the vaues are actually written to the actual attributes.Any suggestions would be greatly appreciated.Thanks,-Dale

Hi, You need to implement a function for validating the UI before saving. Here is an example*************************************************** protected boolean validateUISelection() { boolean flag = true; String s1, s2; Label label1, label2; label1 = (Label)getControl("nameerrorlabel", com.documentum.web.form.control.Label.class); label1.setVisible(false); label2 = (Label)getControl("patherrorlabel", com.documentum.web.form.control.Label.class); label2.setVisible(false); s1 = getObjectName(); if(s1 == null || s1.length() == 0) { label1.setVisible(true); return false; } // Valid File Name, Check for either Path or Assigned Categories being NOT Assigned s1 = getFolderPath(); s2 = getAssignedCategories(); if(((s1 == null) || (s1 == getString("MSG_NONE_SELECTED"))) ((s2 == null) || (s2 == getString("MSG_NONE_SELECTED")))) { label2.setVisible(true); return false; } return flag; }***************************************************Raj

Hi all,

I ve a requirement in iExpenses where on a standard page, i ve a 2 tabs. one for expense lines and other for mileage lines.Both use the same EO.

I ve to check few columns on the expense lines for uniqueness and also have check few other column for mileage lines for uniqueness and should not allow duplicates while updating to the table.

I ve successfully implemented the solution by extending the controller and getting the column values and by creating a prepared statement. But I believe there should be other simple ways to achieve this.

I ruled out EO extension because, i cannot create unique constraint checks for both the scenarios.

Thanks,
Sree.

Any thoughts.

Thanks,
Sree

I've defined an entity bean with CMP. In it, I have a username that I want to check for uniqueness upon creation. To do this, I need to call a finder method from my bean class. Since the container is defining the finder methods using jaws and the Home interface, how do I make this call?-Todd

I ended up using a much more optimal solution (that should get rid of the chance for race conditions...)in the setLoginName method of my ejb class, I get the home interface of my bean and invoke a finder to find duplicates, if one is found, I throw an exception.quick note on throwing exceptions from your ejb class:you must add a throws clause to your main interface, and any create methods in your home interface that call the throwing code.(your compiler will not remind you about any exceptions you've forgotten to throw in your home class)-Todd

Hi!

I have a table with a PK called "ID" and a "Name" field. This field has defined a uniqueness constraint. I need to disable this constraint in order to allow "Name" attribute repeating, and without get rid of table data. I need help!! How can I do this??

Thanks very much to all!!!

I think Carlos wants to drop the UNIQUE constraint on the name column, not the primary key constraint.

If that is the case, he will need to know the name of the constraint (by querying user_cons_columns) and issuing:

ALTER TABLE table_name DROP CONSTRAINT constraint_name;

And, if incapable of querying the dictionary, then using DBA Studio to drill down graphically to the constraint and clicking the checkbox to disable it.

I have 2 questions and would like to ask1. I have a table TABLE[ID,Buyer, Item]I would like to add a constraint that buyer can have multiple item but with quality of 1 only. For example,1 John Pen2. John Pencil3. John Book4. Kerry Pen5. Kerry CD-======== the one below is not correct:1. John Pen2. John Pen Reason: John cannot buy 2 Pen3. John Book4. Kerry Pen5. Kerry CDThe only uniqueness I know is the unique when creating the field of the table, I cannot do this kind of uniqueness. How could I do this one?2. This question is related to IF when creating calculated column,I have a table Member[ExpirationDate, ExpiredYesNO]If the ExpirationDate datenow then ExpiredYesNO = TrueElseif ExpiredYesNO = False.With the help of a forum member, I could create simple computed column but with IF I could not

orcreate table #t(id int identity, Val varchar(50), UniqueFlag bit, [Key] as id*UniqueFlag unique)insert into #t select 'John', 1insert into #t select 'John', 1insert into #t select 'Kerry', 0insert into #t select 'Kerry', 0select * from #tdrop table #thttp://www.t-sql.ru

Hi,
Is the hash code returned by String.hashcode() method unique for all Strings?? If it is not unique, up to what length of string the uniqueness can be ensured??

Your help is greatly appreciated,

Thanks and Regards,
k.s.sridhar

Characters in Java are 2 bytes, so the limit on
uniques hashcodes (theoretically) is 2 characters.In the case of the Java primitive type char you're right of course but I clearly stated I was talking about one-byte characters in general and then I'm right. Characters represented with one byte is still a common situation and the fact that the Java char holds two bytes doesn't change that. So when dealing with one-byte chacters why waste half the available space in the hashcode for storing two 0 bytes?

Conclusion: You can create a unique int hashcode from a string of up to 4 one-byte characters.

Hello,

I created a User table and created Entity Class for it and prepared a controller class for user bean. there is a "create" method in the controller class which persists the user bean to the database and returns an action string for the nagivation. but I think I should check for the uniqueness of the user before persisting it. what's the proper way for doing this kind of things(I mean db-side validation) in JSF?

Thanks

This has nothing to do with JSF. You should post this question in the EJB forums.