Skip to Content
0
Former Member
Jan 17, 2013 at 05:45 PM

profiling column <column_name> is not found in profiling table schema

110 Views

Hi,

I recently installed SAP Information Platform Services, SAP Data Services 4.1, and SAP Information Steward 4.1 on our company's Windows 2008 server where we are using SQL Sever 2008 R2 as our database. Using the CMC, I created a connection to our data store on the SQL server and can see the database and table in Data Insight within Information Steward. However, when attempting to perform column profiling as a test, I am receiving the following error:

[I] 2013-01-17 11:49:34.968 Profiling engine section. (TSK-10015)

[E] 2013-01-17 11:49:35.008 (14.1) 01-17-13 11:49:28 (E) (3840:5072) EML-160409: |Dataflow DF_SPF_NP_5_1

Profiling column <Bin> is not found in the profiling table schema.

(14.1) 01-17-13 11:49:28 (E) (9040:1316) EML-160409: |Dataflow DF_SPF_NP_5_1

Profiling column <Bin> is not found in the profiling table schema.

[I] 2013-01-17 11:49:35.018 The Subtask process [subtask id=81] has finished with error: Profiling column <Bin> is not found in the profiling table schema.. (TSK-10091)

[I] 2013-01-17 11:49:35.158 Processed [1] of [1] sub tasks. (TSK-10047)

[I] 2013-01-17 11:49:35.158 Summary of task [Column] with [1] subtask(s) executed. (TSK-10005)

[I] 2013-01-17 11:49:35.158 [1] Subtask(s) executed with errors. (TSK-10007)

I am not sure if this means additional setup is needed in the DB. Please note that I am not a dba and to get the data into SQL server, I used the import feature and pulled in the data from a pipe delimited flat file which was exported from SAP.

Thanks,

Ken