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.
Profile Stage Unable to select rows from the table
-
- Premium Member
- Posts: 55
- Joined: Tue Feb 24, 2004 8:17 am
-
- Premium Member
- Posts: 55
- Joined: Tue Feb 24, 2004 8:17 am
Re: Profile Stage Unable to select rows from the table
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: