Highlighted
Honored Contributor.
Honored Contributor.
448 views

Need to supress Duplicate Message in change management

Jump to solution

Hi Experts,

I need to supress the below message.(it occurs when there is an duplicate in record)

03/21/17 12:03:18

The record being added contains a duplicate key (format.cjavascript,calc.javascript)

03/21/17 12:03:18

file:(wpopt) key:(id=342192) (format.cjavascript,calc.javascript)

 

How to Do that??

Any Suggestions are appreciated. Thank You,

Regards,

Shalini R

0 Likes
1 Solution

Accepted Solutions
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: Need to supress Duplicate Message in change management

Jump to solution

You can only "suppress" that message by adhering to the database index contraints. That means you cannot add a duplicate record. You could modify the index and add another field that would allow duplicates..

But the better approach would be to modify your script to check if the record exists and alter it instead og added a new..

View solution in original post

0 Likes
4 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Need to supress Duplicate Message in change management

Jump to solution

That message is out of the box and I don't think can be removed.  The only real way is to prevent the situation from occurring.  Do you know why there is a duplicate record being created?

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Re: Need to supress Duplicate Message in change management

Jump to solution

Yes, I know it. Beacuse already we have a records with combination of Change Number and Affected Press in WPOPT Table. But we are trying to insert again.

Example:

It is a automated function which will insert records into the WPOPT table from Cm3r when an RFC in Review Phase. Now we are changing implementation to be in approval Phase. so for existing records, already those were available in WPOPT and when automated script are running, it is showing  a message to users.

SO I need to supress that mesage.

Thanks.

 

0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: Need to supress Duplicate Message in change management

Jump to solution

You can only "suppress" that message by adhering to the database index contraints. That means you cannot add a duplicate record. You could modify the index and add another field that would allow duplicates..

But the better approach would be to modify your script to check if the record exists and alter it instead og added a new..

View solution in original post

0 Likes
Highlighted
Honored Contributor.
Honored Contributor.

Re: Need to supress Duplicate Message in change management

Jump to solution

Hi Tom,

I changed the script, to check the record exist or not. Now records are getting inserted if it doesnt exist and duplicate  error is not coming.

Thank You for your efforts.

Regards,

Shalini R

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.