Score:2

Emptied SQL Server Database broke the Cube

br flag

We have a SQL Server hosting our Analysis Services and accessing data from the ERP system by a ETL process. It was some duplicates in the data and therefore the SQL Server database was emptied. After running the ETL process again the end status is DTSER_SUCCESS. The data in the SQL Server database tables is refreshed and do get an updated Last_Loaded timestamp but nothing will display from the Cube now.

What is the reason for this and how can it be resolved?

This message is in the log file despite the DTSER_SUCCESS status: The external columns for Error Destination are out of synchronization with the data source columns. The external column "OBJID" needs to be updated.

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.