Troubleshooting Informatica Error Messages and Resolution – Part 39

Failed to log on to Siebel database server.
Cause:The Designer was unable to access the Siebel system database server. The network or the database server might not be running properly.
Action:Make sure the network and database are running before trying again.
Invalid Siebel Metadata: Siebel Join <Join name> used by one or more projected fields is not found in the repository.
Cause:The listed Siebel Join does not exist or is not found in the Siebel system.
Action:Disconnect transformations and targets from any application source qualifier port that uses the listed Siebel Join. You can view the fields that use the listed Join on the Attributes tab of a business component in the Source Analyzer properties.
Invalid Siebel Metadata: Siebel Link <Link name> used by one or more projected fields is not found in the repository.
Cause:The listed Siebel Link does not exist or is not found in the Siebel system.
Action:Disconnect transformations and targets from any application source qualifier port that uses the listed Siebel Link. You must query the database underlying the Siebel system for the Multi Value Links that use the listed Destination Link. You can view the fields that use these Multi Value Links on the Attributes tab of a business component in the Source Analyzer properties.
Invalid Siebel Metadata: There is no physical column name for non-calculated field <field name>.
Cause:You created a port in the Siebel business component that is not based on a database column.
Action:Disconnect transformations and targets from any application source qualifier port that uses the listed port.
or
Action:Delete the listed Siebel business component port from the source definition.
Search specification contains unsupported terms.
Cause:Search specification contains expressions using PositionID, RepositoryID, LoginID, IfNull, Iif, or GetProfileAttr.
Action:Siebel search specifications do not allow expression suing PositionID, RepositoryID, IfNull, Iif, or GetProfileAttr. Modify the search specifications.
Search specification is invalid.
Cause:All filed names in the search specification are not enclosed in brackets.
Action:Enclose all field names in search specifications in brackets.
Search specification contains non-projected fields. The search specification will not be processed.
Cause:Search specification has a field that is part of the source but not connected in the mapping to an output port.
Action:Project all fields that are part of the search specification.
Search specification contains calculated fields. The search specification will not be processed.
Cause:Search specification includes calculated fields.
Action:Remove all calculated fields from specifications. Search specifications cannot include calculated fields.

Above are list of Informatica Error Messages or Warnings received while performing certain operation against Informatica related products.

What are Informatica Error Messages?

Informatica error codes are a set of error codes for use by all Informatica products. Every Informatica error message returned by Informatica, is self explanatory and contains the object name in cases where required.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Informatica Error Code Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *