Profile Stage Unable to select rows from the table

[anandkumarm]

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.

[anandkumarm]

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.

[ray.wurlod]

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