Focal Point
[Closed] - Error Loading Customer Dimension - PMF

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/6687016586

February 22, 2017, 11:28 AM
Jasen
[Closed] - Error Loading Customer Dimension - PMF
I am getting a violation of primary key constraint error, can't insert duplicate key. When looking at the data I can't find any duplicate values. The load will use Market Type, Customer Group and Customer as the levels. I can get the data to load when I only use two of the levels (you can pick any two), but when I add the third I get the error message attached.

This message has been edited. Last edited by: Jasen,




WebFocus 8.002
PMF 8.2.3
Windows, all output
February 22, 2017, 11:38 AM
Bob Jude Ferrante
Hi Jasen,

This error message comes from the RDBMS, doesn't happen during normal operation. Could have something to do with limitations on the schema name or other similar RDBMS issue.

Can you take this one to customer support?

They will want to follow up with the steps that led to this error message.

Naturally we'll jump on the issue to help.

thanks


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

March 01, 2017, 08:33 PM
Jasen
Customer Dimension has been loaded.


WebFocus 8.002
PMF 8.2.3
Windows, all output