Monday, November 21, 2011 1:43 PM
I'm using RC0 of PowerPivot for Excel 32 and have installed TDOLEDB (from Teradata). TD is running 13.1 version.
From Other Source, I select Teradata and sign in with server + username/password and selecting 'Select from a list of tables...' provides me with a list of tables that I can access.
Bad case # 1
If I select a table (any table really) and hits Preview & Filter, the connection works and data is retrieved and displayed as expected. However, sorting and filtering in the preview windows is slow to the verge of just hanging. However, all rows and columns are available.
Bad case # 2
If I hit OK, the wizard starts reading the content from Teradata but one of two things happen. Either will only datatime columns be returned and every other column is missing. Or, in some cases I get an error stating "The 'Tp_nm' column does not exist in the rowset. An error occurred while processing the 'Agreement_type' table. The current operation was cancelled because another operation in the transaction failed.
If I use the classic Data tab in Excel and connects to TD using the From Data Connection Wizard and Other/Advanced with the same server name and username/password as from PowerPivot everything works. I can connect to the same set of tables and easily import tables with correct content into Excel. Every column is present and no error.
The only difference in TDOLEDB parameters is that the Excel version is using Character Set ASCII explicitly stated.
However, going back to PowerPivot and setting this as a parameter only brings more details to the error message. "The 'Tp_nm' column does not exist in the rowset. An error occured while the partition, with the ID of 'Agreement_Type_<guid>'. Name of 'Agreement_type' was being processed. The current operation was cancelled because another operation in the transaction failed. Out of line object 'DataSource', referring ot ID(s) <guid>, has beenspecified but has not been used."