Troubleshooting Informatica Error Messages and Resolution – Part 238

SQLServerF1

OPT_63207Partition Count is 1. Dynamic Partitioning has been disabled.
Cause:The Number of Partitions session attribute is 1. The session runs in one partition.
Action:Set the number of partitions to a number greater than 1, or change the method of partitioning.

OPT_63213Error retrieving database partition information <database name>.
Cause:When you use database partitioning, the Integration Service generates SQL queries to access data in each database partition. The Integration Service queries of the database system catalog failed.
Action:Review previous messages to determine why the database is inaccessible.
OPT_63214 Error retrieving partitions.
Cause:The Integration Service is using database partitioning, but it cannot retrieve partition IDs or partition names.
Action:Review previous messages to determine why the partitions are inaccessible.
OPT_63215 Error partitioning session attributes.
Cause:The Integration Service could not create partition-level attributes for dynamic partitions.
Action:Verify that you enter valid values for the session parameters that the Integration Service uses to create dynamic partition attributes. Partition-level attributes include source, target, and reject file names and locations.

OPT_63216 Error partitioning key range for transformation <transformation name>.
Cause:You are using key range partitioning and the Integration Service cannot partition the key ranges you defined for a transformation.
Action:Verify the key ranges do not have gaps or overlapping ranges.
OPT_63217 Transformation <transformation name> uses a key range data type that cannot be partitioned.
Cause:The key range partition key must be a number or a date for a dynamic partitioned session.
Action:Disable dynamic partitioning or change the key type to a number or date.
OPT_63218Key range not closed.
Cause:You cannot enable dynamic partitioning for a transformation that uses an open range of partition key numbers.
Action:Disable dynamic partitioning or change the key range to a closed range of numbers.

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 *