Have you confirmed the PWH content has been created? Go to the Data Integration Service Properties; if the contents don't exist there will be a notification message in red.
Yes, the Profiling Warehouse Database Properties are all populated. Is that the section which you are referring?
When I go to create the Profiling Database Warehouse Contents, I get the error Invalid Value for Database connection details. But all values appear to be populated correctly.
1 of 1 people found this helpful
On the DIS Properties page, is the Profiling Warehouse Database Properties -> Profiling Warehouse Database property set? If not, click edit and choose your Profiling Warehouse DB connection.
If the property is set, go to the Administration Console -> select Connections -> choose the Profiling Warehouse connection -> Select the Action menu (top right of window) and choose Test Connection.
Thanks. That appears to be the issue. I am getting a ORA-12514 Listener error on that connection.
In the data integration service, actions..profile. Warehouse…create content
not able to create content in schema level.
Please do the following:
- Share the DIS logs around the time when you tried to create the Profile Warehouse Contents.
- Perform test connection on Profile Warehouse Connection in Admin Console > Connections tab. Does it succeed?
- What is the database type of the connection being used for for Profile Warehouse (PWH)?
- Share the screenshot of DIS > Properties tab to confirm if there are any errors/warnings related to PWH.