Troubleshooting Informatica Error Messages and Resolution – Part 90

SQLServerF1_Header_Small

CMN_1694Database Event Unable to set DBARITHABORT: Arithmetic exceptions from Microsoft SQL Server will not cancel query execution.
Cause:The Integration Service failed to set database option DBARITHABORT for a database connection to Microsoft SQL Server.
Action:Make sure Microsoft SQL Server is running and check Microsoft SQL Server network settings so that the Integration Service can connect to the database and set the DBARITHABORT option.

CMN_1695Database Event Unable to set options: Options cannot be set in Microsoft SQL Server.
Cause:The Integration Service failed to set any database option for a database connection to Microsoft SQL Server.
Action:Make sure Microsoft SQL Server is running and you can set the database connection and database connection options.
CMN_1701Error: Data for Lookup <transformation name> fetched from the database is not sorted on the condition ports. Please check your Lookup SQL override.
Cause:You specified a SQL override for this Lookup transformation and specified the ORDER BY clause incorrectly.
Action:When you override the lookup query ORDER BY clause, you must put the condition ports first.
CMN_1702Error attaching to system shared memory <ID> for <Load Manager Shared Memory> at address <address>. System error is <error number> <error message>. (UNIX only)
Cause:Internal error.
Action:Contact Informatica Technical Support.

CMN_1703Error attaching to system shared memory <ID> for <Load Manager Shared Memory> at address <address>. System error is <error number>. (Windows only)
Cause:The address you specified in the Shared Memory Base Address is already in use.
Action:Change the address in the Integration Service configuration.
CMN_1704Error attaching to system shared memory <ID> for <Load Manager Shared Memory>. Expected to attach at address <address>, but attached at <address>.
Cause:Internal error.
Action:Contact Informatica Technical Support.

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 *