DSXchange

Hi,

I am using ProfileStage
Version 7.51 build 10. on
OS : Windows NT

While running the column analysis I am getting the following error:

6/6 11:56:58: \\HDMCJUNAPPTST8\ColumnAnalysis: 5070 0 Unable to select rows from table 'Talon_C1479' at DSN 'sap_lcm_cm_ps_work'.

I am able to do the column analysis on other tables on the same database except for this table.
The complete process log is as follows:

6/6 11:56:58: \\HDMCJUNAPPTST8\ColumnAnalysis: 5039 0 Program ColumnAnalysis running. Computer: HDMCJUNAPPTST8. Process ID: 2360. Program ID: 89.
6/6 11:56:58: \\HDMCJUNAPPTST8\ColumnAnalysis: FILE - INI HDMCJUNAPPTST8 0 D:\Apps\Ascential\ProfileStage\AnalysisServer\LogFiles\ColumnAnalysis_20060606_11.ini
6/6 11:56:58: \\HDMCJUNAPPTST8\ColumnAnalysis: 23 0 Program initialization is now complete.
6/6 11:56:58: \\HDMCJUNAPPTST8\ColumnAnalysis: 5068 0 Started processing table Talon_C1479.
6/6 11:56:58: \\HDMCJUNAPPTST8\ColumnAnalysis: 5070 0 Unable to select rows from table 'Talon_C1479' at DSN 'sap_lcm_cm_ps_work'.
6/6 11:56:58: \\HDMCJUNAPPTST8\ColumnAnalysis: 5041 0 Finished processing for table Talon_C1479. 0 tables to be processed.
6/6 11:56:58: Column Analysis Done.
Process completed successfully.

When I click the view source button I am able to view the data, but the column analysis is unable to select the data form the table.

Can anybody provide help on this issue?

Thanks,
Anand.

Resolved with the help of Rhys Jones on developernet. The table contained fields with reserved words as their field names I changed them and it works now.

You might also have been able to enclose the reserved names in double quotes in your SQL.