| Product(s): | Exor Information Manager | ||
| Version(s): | 4.5.0.0 | ||
| Environment: | N/A | ||
| Area: | Pods | ||
| Subarea: | N/A |
Problem
Trying to search for an enquiry using the Pod 'Find Enquiry'. However, after entering a search term, the following error message appears:
ORA-00904 "C061" invalid identifier
Solution
The error is due to a limitation on the number of columns displayed within IM4 (60 fields). The number of columns needs to be reduced in order for the search to return results successfully. In order to adjust the number of fields, following the instructions below:
- Log into IM4 and select the 'Admin' tab.
- In the left hand pane, select 'Pod Maintenance'.
- Edit the Module IM1200.
- Under the section 'Pod Source', make a copy of the source code and remove the fields you do not require from the 'select' statement.
- Apply changes and run the FInd Enquiry Pod.
See Also
External Links
Bentley Technical Support KnowledgeBase
Comments or Corrections?
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!
| Original Author: | Fezan Khan |