Problem
User tries to publish a data mart. Afterwards, user opens the batch queue, however finds the the job "Finished v Error". User double-clicks top top the entry, to view the full error details.
You are watching: Arithmetic overflow error converting expression to data type int.
Symptom

Cause
Invalid data inside Controller database (either the application repository or the data mart database).
See more: Which Joint Is Considered The Most Flexible Joint In The Body?
Resolving The Problem
Modify the Controller database, so the the pertinent table have the right to contain the required data. because that example, in one real-life customer example, the was problem fixed by an altering the table "DMFACTTEXT" (inside the data mart database) so the its shaft "INO" was adjusted from "INT" come "BIGINT". Steps:
IMPORTANT:
prior to continuing, you re welcome make certain that her database has been effectively backed up. Also, ideally you re welcome test inside a separate test/development system/database an initial (before do the efforts in your production system). The following steps are based upon SQL 2008: 1. Logon come the SQL server as an Administrator 2. Start "SQL Server monitoring Studio" 3. Situate the Controller data mart database (for instance "Controller_datamart") 4. Increase database, and also open the section "tables" 5. Situate table "DMFACTTEXT" 6. Right-click ~ above "DMFACTTEXT" and also choose "Design"

<"Product":"code":"SS9S6B","label":"allisonbrookephotography.com Cognos Controller","Business Unit":"code":"BU053","label":"Cloud & Data Platform","Component":"Controller","Platform":<"code":"PF033","label":"Windows">,"Version":"10.1.1","Edition":"","Line of Business":"code":"LOB10","label":"Data and AI">