on 05-06-2015 7:18 PM
Hi,
I recently changed the connection source of a universe from a SQL 2005 Server database to a SQL 2012 database. Although the underlying data is pretty much the same, slight changes might have occurred in the database. After changing the connection, I restructured the universe and tried to count the rows again and came across the following error:
dimGlobalCurrentInvoiceCustomerTbl: Failed to execute runnable (java.lang.RuntimeException: Failed to execute: SELECT COUNT(*) FROM (SELECT
dimGlobalCurrentInvoiceCustomerTbl.globalCurrentInvoiceCustomerID,
dimGlobalCurrentInvoiceCustomerTbl.loadDate,
dimGlobalCurrentInvoiceCustomerTbl.localCustomerNumberDesc,
dimGlobalCurrentInvoiceCustomerTbl.customerNameDesc,
dimGlobalCurrentInvoiceCustomerTbl.globalCustomerNumberDesc,
dimGlobalCurrentInvoiceCustomerTbl.customerTypeDesc,
dimGlobalCurrentInvoiceCustomerTbl.invAddressDesc,
dimGlobalCurrentInvoiceCustomerTbl.invCityDesc,
dimGlobalCurrentInvoiceCustomerTbl.invCountyDesc,
dimGlobalCurrentInvoiceCustomerTbl.invCountryDesc,
dimGlobalCurrentInvoiceCustomerTbl.invZipDesc,
dimGlobalCurrentInvoiceCustomerTbl.invStateDesc,
dimGlobalCurrentInvoiceCustomerTbl.invPhoneDesc,
dimGlobalCurrentInvoiceCustomerTbl.invFaxDesc,
dimGlobalCurrentInvoiceCustomerTbl.invEMailDesc,
dimGlobalCurrentInvoiceCustomerTbl.customerKeyAccount,
dimGlobalCurrentInvoiceCustomerTbl.areaLoadTimestamp,
dimGlobalCurrentInvoiceCustomerTbl.sourceArea
FROM
dimGlobalCurrentInvoiceCustomerTbl
) T
)
There is a bunch of similar kinds of messages appending this one.
Does anyone have any idea what could be the cause of this?
Thanks!
--Sakshi
Hi Sakshi - Did you do an integrity check after the connection change ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I did an integrity check after you asked and got a several warning indicating missing primary keys and 4 errors indicating undetermined cardinality. I tried to resolve the error but, I'm unable to determine cardinality of some joins since there is no data in some of the underlying tables.
Do you think its more of a data issue then?
You need to fix these error for sure to make the universe clean. I asked you to do the integrity check because there was an uncertainty over what has changed in the underlying database.
Now, did you try to execute the count statement using a standard DB front-end (Toad, MS SQL studio) ? were you successful in getting the count for the dimGlobalCurrentInvoiceCustomerTbl?
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.