- Posts: 19
- Thank you received: 0
duplicate values in the index primary key or relationship
- josimarviana
- Topic Author
- Offline
- New Member
-
Less
More
8 years 2 months ago #13292
by josimarviana
May you help me?
I don't know why but my ETL shows this message when I execute a extract proccess. How can I fix it?
Information 14/07/2015 07:10:06 Preparing to execute: Embossing_AtualDv
Error 14/07/2015 07:10:06 Package has failed
Error 14/07/2015 07:10:06 The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again
Thanks
I don't know why but my ETL shows this message when I execute a extract proccess. How can I fix it?
Information 14/07/2015 07:10:06 Preparing to execute: Embossing_AtualDv
Error 14/07/2015 07:10:06 Package has failed
Error 14/07/2015 07:10:06 The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again
Thanks
Please Log in or Create an account to join the conversation.
8 years 2 months ago #13293
by admin
Mike
ETL Architect
Replied by admin on topic duplicate values in the index primary key or relationship
Well you are inserting duplicated data,
Don't you think it is obvious that there is a problem with the data an you have to sort it out?
Don't you think it is obvious that there is a problem with the data an you have to sort it out?
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- josimarviana
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 19
- Thank you received: 0
8 years 2 months ago #13294
by josimarviana
Replied by josimarviana on topic duplicate values in the index primary key or relationship
Sorry Mike, but I forgot to say that this message is generated by ETL. It didn't insert some information in their database log.
This message isn't from the business process.
This message isn't from the business process.
Please Log in or Create an account to join the conversation.
8 years 2 months ago - 8 years 2 months ago #13295
by admin
Mike
ETL Architect
Replied by admin on topic duplicate values in the index primary key or relationship
The problem is that you are asking us to "GUESS" what is the problem.
Harry Porter does not work for our department.
We can't travel trough space and time and see what happening on your screen
You have to provide detailed description and a lot of useful screenshots.
Than we will be able to help you.
(Read the forum rules first)
Harry Porter does not work for our department.
We can't travel trough space and time and see what happening on your screen
You have to provide detailed description and a lot of useful screenshots.
Than we will be able to help you.
(Read the forum rules first)
Mike
ETL Architect
Last edit: 8 years 2 months ago by admin.
The following user(s) said Thank You: josimarviana
Please Log in or Create an account to join the conversation.
- josimarviana
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 19
- Thank you received: 0
8 years 2 months ago - 8 years 2 months ago #13296
by josimarviana
Replied by josimarviana on topic duplicate values in the index primary key or relationship
Sorry, I coudn't want to bore you. Thank's that polite way that you reply your customers. I will put it in my facebook timeline as "way that etl-tools.com help your customers". Thank you.
Last edit: 8 years 2 months ago by josimarviana.
Please Log in or Create an account to join the conversation.
8 years 2 months ago #13297
by admin
Mike
ETL Architect
Replied by admin on topic duplicate values in the index primary key or relationship
I am sorry that you feel that my comments are rude.
All we want do is to help you as soon as possible first without forcing you to wait for days.
The forum rules are here you help you.
Some time we have "to beg" our customers to provide us with correct information.
This is part of our everyday work.
Our software has a lot screens.
Here is what I am trying to do
Screenshot
When I press this button.
Screenshot
I get this error
Screenshot
So it really that difficult to provide this kind of formation?
Or is rude to ask for it?
Is it rude to ask to follow the forum rules?
All we want do is to help you as soon as possible first without forcing you to wait for days.
The forum rules are here you help you.
Some time we have "to beg" our customers to provide us with correct information.
This is part of our everyday work.
Our software has a lot screens.
Here is what I am trying to do
Screenshot
When I press this button.
Screenshot
I get this error
Screenshot
So it really that difficult to provide this kind of formation?
Or is rude to ask for it?
Is it rude to ask to follow the forum rules?
Mike
ETL Architect
Please Log in or Create an account to join the conversation.