6 Replies Latest reply on Jun 7, 2017 7:34 AM by 1003344

    Error on importing data with zero balances using UDA

    1003344

      Hello all,

       

      I am trying to import data from a view in an Oracle database using the Universal Data Adapter (UDA), but this view contains zero values, if the rule supposed to import data on a month that contains only Zero data and i chose "Exclude zero balances" the following error occurs:

       

      2017-05-22 14:52:56,382 INFO  [AIF]:

      Map Data for Period 'OCT-17'

      2017-05-22 14:52:56,386 WARN  [AIF]:

      Warning: Data rows with zero balances exist

      2017-05-22 14:52:56,386 INFO  [AIF]: Zero Balance Data Rows Deleted: 1

      2017-05-22 14:52:56,386 ERROR [AIF]: Error: No records exist for Period 'OCT-17'

      2017-05-22 14:52:56,408 FATAL [AIF]: Error in CommMap.updateTDATASEG_T_TDATASEGW

      Traceback (most recent call last):

        File "<string>", line 1729, in updateTDATASEG_T_TDATASEGW

      RuntimeError: Error: No records exist for Period 'OCT-17'

       

      And then it continue importing for the rest of the months but it stops on trasnforming the data as per the screenshot:

      hangs.PNG

      The full log as follow:

       

      2017-05-22 14:51:31,105 INFO  [AIF]: FDMEE Process: 634, Log Level: 4, Log File: E:\FDMEE_UAT\outbox\logs\ABABUD_634.log

      2017-05-22 14:51:31,105 INFO  [AIF]: Location     : Oracle_Projects (Partitionkey:12)

      2017-05-22 14:51:31,105 INFO  [AIF]: Period Name  : JAN-17 (Period Key:1/1/17 12:00 AM)

      2017-05-22 14:51:31,105 INFO  [AIF]: Category Name: Actual (Category key:1)

      2017-05-22 14:51:31,105 INFO  [AIF]: Rule Name    : Oracle_Projects (Rule ID:36)

      2017-05-22 14:51:35,185 INFO  [AIF]: FDM Version: 11.1.2.4.210

      2017-05-22 14:51:35,185 INFO  [AIF]: Log File Encoding: UTF-8

      2017-05-22 14:51:38,537 INFO  [AIF]: -------START IMPORT STEP-------

      2017-05-22 14:52:53,943 INFO  [AIF]:

      Import Data from Source for Period 'JAN-17'

      2017-05-22 14:52:53,962 INFO  [AIF]: Generic Data Rows Imported from Source: 2

      2017-05-22 14:52:53,965 INFO  [AIF]: Total Data Rows Imported from Source: 2

      2017-05-22 14:52:53,965 INFO  [AIF]:

      Import Data from Source for Period 'Feb-17'

      2017-05-22 14:52:53,972 INFO  [AIF]: Generic Data Rows Imported from Source: 1

      2017-05-22 14:52:53,974 INFO  [AIF]: Total Data Rows Imported from Source: 1

      2017-05-22 14:52:53,974 INFO  [AIF]:

      Import Data from Source for Period 'MAR-17'

      2017-05-22 14:52:53,981 INFO  [AIF]: Generic Data Rows Imported from Source: 1

      2017-05-22 14:52:53,983 INFO  [AIF]: Total Data Rows Imported from Source: 1

      2017-05-22 14:52:53,983 INFO  [AIF]:

      Import Data from Source for Period 'APR-17'

      2017-05-22 14:52:53,990 INFO  [AIF]: Generic Data Rows Imported from Source: 17

      2017-05-22 14:52:53,993 INFO  [AIF]: Total Data Rows Imported from Source: 17

      2017-05-22 14:52:53,993 INFO  [AIF]:

      Import Data from Source for Period 'MAY-17'

      2017-05-22 14:52:53,999 INFO  [AIF]: Generic Data Rows Imported from Source: 17

      2017-05-22 14:52:54,002 INFO  [AIF]: Total Data Rows Imported from Source: 17

      2017-05-22 14:52:54,002 INFO  [AIF]:

      Import Data from Source for Period 'JUN-17'

      2017-05-22 14:52:54,008 INFO  [AIF]: Generic Data Rows Imported from Source: 15

      2017-05-22 14:52:54,011 INFO  [AIF]: Total Data Rows Imported from Source: 15

      2017-05-22 14:52:54,011 INFO  [AIF]:

      Import Data from Source for Period 'JUL-17'

      2017-05-22 14:52:54,018 INFO  [AIF]: Generic Data Rows Imported from Source: 14

      2017-05-22 14:52:54,020 INFO  [AIF]: Total Data Rows Imported from Source: 14

      2017-05-22 14:52:54,020 INFO  [AIF]:

      Import Data from Source for Period 'AUG-17'

      2017-05-22 14:52:54,027 INFO  [AIF]: Generic Data Rows Imported from Source: 5

      2017-05-22 14:52:54,029 INFO  [AIF]: Total Data Rows Imported from Source: 5

      2017-05-22 14:52:54,029 INFO  [AIF]:

      Import Data from Source for Period 'SEP-17'

      2017-05-22 14:52:54,036 INFO  [AIF]: Generic Data Rows Imported from Source: 1

      2017-05-22 14:52:54,038 INFO  [AIF]: Total Data Rows Imported from Source: 1

      2017-05-22 14:52:54,038 INFO  [AIF]:

      Import Data from Source for Period 'OCT-17'

      2017-05-22 14:52:54,045 INFO  [AIF]: Generic Data Rows Imported from Source: 1

      2017-05-22 14:52:54,047 INFO  [AIF]: Total Data Rows Imported from Source: 1

      2017-05-22 14:52:54,047 INFO  [AIF]:

      Import Data from Source for Period 'NOV-17'

      2017-05-22 14:52:54,054 INFO  [AIF]: Generic Data Rows Imported from Source: 1

      2017-05-22 14:52:54,056 INFO  [AIF]: Total Data Rows Imported from Source: 1

      2017-05-22 14:52:54,056 INFO  [AIF]:

      Import Data from Source for Period 'DEC-17'

      2017-05-22 14:52:54,063 INFO  [AIF]: Generic Data Rows Imported from Source: 0

      2017-05-22 14:52:54,063 INFO  [AIF]: Total Data Rows Imported from Source: 0

      2017-05-22 14:52:56,131 INFO  [AIF]:

      Map Data for Period 'JAN-17'

      2017-05-22 14:52:56,144 INFO  [AIF]:

      Processing Mappings for Column 'ACCOUNT'

      2017-05-22 14:52:56,146 INFO  [AIF]: Data Rows Updated by Location Mapping 'Projects' (LIKE): 2

      2017-05-22 14:52:56,146 INFO  [AIF]:

      Processing Mappings for Column 'ENTITY'

      2017-05-22 14:52:56,147 INFO  [AIF]: Data Rows Updated by Location Mapping 'Ignore' (IN): 0

      2017-05-22 14:52:56,148 INFO  [AIF]: Data Rows Updated by Location Mapping 'Entity' (LIKE): 2

      2017-05-22 14:52:56,148 INFO  [AIF]:

      Processing Mappings for Column 'UD1'

      2017-05-22 14:52:56,149 INFO  [AIF]: Data Rows Updated by Location Mapping 'Active' (LIKE): 2

      2017-05-22 14:52:56,149 INFO  [AIF]:

      Processing Mappings for Column 'UD10'

      2017-05-22 14:52:56,150 INFO  [AIF]: Data Rows Updated by Location Mapping 'Inc' (LIKE): 2

      2017-05-22 14:52:56,150 INFO  [AIF]:

      Processing Mappings for Column 'UD11'

      2017-05-22 14:52:56,151 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 2

      2017-05-22 14:52:56,155 INFO  [AIF]: Data Rows Updated by Location Mapping 'Agency' (LIKE): 0

      2017-05-22 14:52:56,155 INFO  [AIF]:

      Processing Mappings for Column 'UD2'

      2017-05-22 14:52:56,156 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 2

      2017-05-22 14:52:56,157 INFO  [AIF]: Data Rows Updated by Location Mapping 'Location' (LIKE): 0

      2017-05-22 14:52:56,157 INFO  [AIF]:

      Processing Mappings for Column 'UD3'

      2017-05-22 14:52:56,159 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 2

      2017-05-22 14:52:56,160 INFO  [AIF]: Data Rows Updated by Location Mapping 'Cost center' (LIKE): 0

      2017-05-22 14:52:56,160 INFO  [AIF]:

      Processing Mappings for Column 'UD6'

      2017-05-22 14:52:56,161 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,163 INFO  [AIF]: Data Rows Updated by Location Mapping 'LOB' (LIKE): 2

      2017-05-22 14:52:56,163 INFO  [AIF]:

      Processing Mappings for Column 'UD8'

      2017-05-22 14:52:56,164 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,165 INFO  [AIF]: Data Rows Updated by Location Mapping 'Project' (LIKE): 2

      2017-05-22 14:52:56,165 INFO  [AIF]:

      Processing Mappings for Column 'UD9'

      2017-05-22 14:52:56,166 INFO  [AIF]: Data Rows Updated by Location Mapping 'Asset_Detail' (LIKE): 2

      2017-05-22 14:52:56,169 INFO  [AIF]:

      Map Data for Period 'Feb-17'

      2017-05-22 14:52:56,173 INFO  [AIF]:

      Processing Mappings for Column 'ACCOUNT'

      2017-05-22 14:52:56,174 INFO  [AIF]: Data Rows Updated by Location Mapping 'Projects' (LIKE): 1

      2017-05-22 14:52:56,175 INFO  [AIF]:

      Processing Mappings for Column 'ENTITY'

      2017-05-22 14:52:56,175 INFO  [AIF]: Data Rows Updated by Location Mapping 'Ignore' (IN): 0

      2017-05-22 14:52:56,177 INFO  [AIF]: Data Rows Updated by Location Mapping 'Entity' (LIKE): 1

      2017-05-22 14:52:56,177 INFO  [AIF]:

      Processing Mappings for Column 'UD1'

      2017-05-22 14:52:56,177 INFO  [AIF]: Data Rows Updated by Location Mapping 'Active' (LIKE): 1

      2017-05-22 14:52:56,178 INFO  [AIF]:

      Processing Mappings for Column 'UD10'

      2017-05-22 14:52:56,178 INFO  [AIF]: Data Rows Updated by Location Mapping 'Inc' (LIKE): 1

      2017-05-22 14:52:56,179 INFO  [AIF]:

      Processing Mappings for Column 'UD11'

      2017-05-22 14:52:56,180 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-05-22 14:52:56,181 INFO  [AIF]: Data Rows Updated by Location Mapping 'Agency' (LIKE): 0

      2017-05-22 14:52:56,181 INFO  [AIF]:

      Processing Mappings for Column 'UD2'

      2017-05-22 14:52:56,182 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-05-22 14:52:56,183 INFO  [AIF]: Data Rows Updated by Location Mapping 'Location' (LIKE): 0

      2017-05-22 14:52:56,183 INFO  [AIF]:

      Processing Mappings for Column 'UD3'

      2017-05-22 14:52:56,184 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-05-22 14:52:56,185 INFO  [AIF]: Data Rows Updated by Location Mapping 'Cost center' (LIKE): 0

      2017-05-22 14:52:56,185 INFO  [AIF]:

      Processing Mappings for Column 'UD6'

      2017-05-22 14:52:56,186 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,187 INFO  [AIF]: Data Rows Updated by Location Mapping 'LOB' (LIKE): 1

      2017-05-22 14:52:56,187 INFO  [AIF]:

      Processing Mappings for Column 'UD8'

      2017-05-22 14:52:56,188 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,189 INFO  [AIF]: Data Rows Updated by Location Mapping 'Project' (LIKE): 1

      2017-05-22 14:52:56,189 INFO  [AIF]:

      Processing Mappings for Column 'UD9'

      2017-05-22 14:52:56,190 INFO  [AIF]: Data Rows Updated by Location Mapping 'Asset_Detail' (LIKE): 1

      2017-05-22 14:52:56,193 INFO  [AIF]:

      Map Data for Period 'MAR-17'

      2017-05-22 14:52:56,196 INFO  [AIF]:

      Processing Mappings for Column 'ACCOUNT'

      2017-05-22 14:52:56,197 INFO  [AIF]: Data Rows Updated by Location Mapping 'Projects' (LIKE): 1

      2017-05-22 14:52:56,197 INFO  [AIF]:

      Processing Mappings for Column 'ENTITY'

      2017-05-22 14:52:56,198 INFO  [AIF]: Data Rows Updated by Location Mapping 'Ignore' (IN): 0

      2017-05-22 14:52:56,199 INFO  [AIF]: Data Rows Updated by Location Mapping 'Entity' (LIKE): 1

      2017-05-22 14:52:56,199 INFO  [AIF]:

      Processing Mappings for Column 'UD1'

      2017-05-22 14:52:56,200 INFO  [AIF]: Data Rows Updated by Location Mapping 'Active' (LIKE): 1

      2017-05-22 14:52:56,200 INFO  [AIF]:

      Processing Mappings for Column 'UD10'

      2017-05-22 14:52:56,201 INFO  [AIF]: Data Rows Updated by Location Mapping 'Inc' (LIKE): 1

      2017-05-22 14:52:56,201 INFO  [AIF]:

      Processing Mappings for Column 'UD11'

      2017-05-22 14:52:56,202 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-05-22 14:52:56,203 INFO  [AIF]: Data Rows Updated by Location Mapping 'Agency' (LIKE): 0

      2017-05-22 14:52:56,203 INFO  [AIF]:

      Processing Mappings for Column 'UD2'

      2017-05-22 14:52:56,204 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-05-22 14:52:56,205 INFO  [AIF]: Data Rows Updated by Location Mapping 'Location' (LIKE): 0

      2017-05-22 14:52:56,205 INFO  [AIF]:

      Processing Mappings for Column 'UD3'

      2017-05-22 14:52:56,206 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-05-22 14:52:56,207 INFO  [AIF]: Data Rows Updated by Location Mapping 'Cost center' (LIKE): 0

      2017-05-22 14:52:56,207 INFO  [AIF]:

      Processing Mappings for Column 'UD6'

      2017-05-22 14:52:56,208 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,209 INFO  [AIF]: Data Rows Updated by Location Mapping 'LOB' (LIKE): 1

      2017-05-22 14:52:56,209 INFO  [AIF]:

      Processing Mappings for Column 'UD8'

      2017-05-22 14:52:56,210 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,211 INFO  [AIF]: Data Rows Updated by Location Mapping 'Project' (LIKE): 1

      2017-05-22 14:52:56,211 INFO  [AIF]:

      Processing Mappings for Column 'UD9'

      2017-05-22 14:52:56,212 INFO  [AIF]: Data Rows Updated by Location Mapping 'Asset_Detail' (LIKE): 1

      2017-05-22 14:52:56,215 INFO  [AIF]:

      Map Data for Period 'APR-17'

      2017-05-22 14:52:56,221 WARN  [AIF]:

      Warning: Data rows with zero balances exist

      2017-05-22 14:52:56,221 INFO  [AIF]: Zero Balance Data Rows Deleted: 1

      2017-05-22 14:52:56,221 INFO  [AIF]:

      Processing Mappings for Column 'ACCOUNT'

      2017-05-22 14:52:56,222 INFO  [AIF]: Data Rows Updated by Location Mapping 'Projects' (LIKE): 16

      2017-05-22 14:52:56,222 INFO  [AIF]:

      Processing Mappings for Column 'ENTITY'

      2017-05-22 14:52:56,223 INFO  [AIF]: Data Rows Updated by Location Mapping 'Ignore' (IN): 0

      2017-05-22 14:52:56,224 INFO  [AIF]: Data Rows Updated by Location Mapping 'Entity' (LIKE): 16

      2017-05-22 14:52:56,224 INFO  [AIF]:

      Processing Mappings for Column 'UD1'

      2017-05-22 14:52:56,226 INFO  [AIF]: Data Rows Updated by Location Mapping 'Active' (LIKE): 16

      2017-05-22 14:52:56,226 INFO  [AIF]:

      Processing Mappings for Column 'UD10'

      2017-05-22 14:52:56,227 INFO  [AIF]: Data Rows Updated by Location Mapping 'Inc' (LIKE): 16

      2017-05-22 14:52:56,227 INFO  [AIF]:

      Processing Mappings for Column 'UD11'

      2017-05-22 14:52:56,229 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 16

      2017-05-22 14:52:56,230 INFO  [AIF]: Data Rows Updated by Location Mapping 'Agency' (LIKE): 0

      2017-05-22 14:52:56,230 INFO  [AIF]:

      Processing Mappings for Column 'UD2'

      2017-05-22 14:52:56,232 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 16

      2017-05-22 14:52:56,233 INFO  [AIF]: Data Rows Updated by Location Mapping 'Location' (LIKE): 0

      2017-05-22 14:52:56,233 INFO  [AIF]:

      Processing Mappings for Column 'UD3'

      2017-05-22 14:52:56,235 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 16

      2017-05-22 14:52:56,236 INFO  [AIF]: Data Rows Updated by Location Mapping 'Cost center' (LIKE): 0

      2017-05-22 14:52:56,236 INFO  [AIF]:

      Processing Mappings for Column 'UD6'

      2017-05-22 14:52:56,237 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,239 INFO  [AIF]: Data Rows Updated by Location Mapping 'LOB' (LIKE): 16

      2017-05-22 14:52:56,239 INFO  [AIF]:

      Processing Mappings for Column 'UD8'

      2017-05-22 14:52:56,240 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,241 INFO  [AIF]: Data Rows Updated by Location Mapping 'Project' (LIKE): 16

      2017-05-22 14:52:56,241 INFO  [AIF]:

      Processing Mappings for Column 'UD9'

      2017-05-22 14:52:56,243 INFO  [AIF]: Data Rows Updated by Location Mapping 'Asset_Detail' (LIKE): 16

      2017-05-22 14:52:56,247 INFO  [AIF]:

      Map Data for Period 'MAY-17'

      2017-05-22 14:52:56,251 WARN  [AIF]:

      Warning: Data rows with zero balances exist

      2017-05-22 14:52:56,251 INFO  [AIF]: Zero Balance Data Rows Deleted: 1

      2017-05-22 14:52:56,251 INFO  [AIF]:

      Processing Mappings for Column 'ACCOUNT'

      2017-05-22 14:52:56,253 INFO  [AIF]: Data Rows Updated by Location Mapping 'Projects' (LIKE): 16

      2017-05-22 14:52:56,253 INFO  [AIF]:

      Processing Mappings for Column 'ENTITY'

      2017-05-22 14:52:56,254 INFO  [AIF]: Data Rows Updated by Location Mapping 'Ignore' (IN): 0

      2017-05-22 14:52:56,256 INFO  [AIF]: Data Rows Updated by Location Mapping 'Entity' (LIKE): 16

      2017-05-22 14:52:56,256 INFO  [AIF]:

      Processing Mappings for Column 'UD1'

      2017-05-22 14:52:56,257 INFO  [AIF]: Data Rows Updated by Location Mapping 'Active' (LIKE): 16

      2017-05-22 14:52:56,257 INFO  [AIF]:

      Processing Mappings for Column 'UD10'

      2017-05-22 14:52:56,259 INFO  [AIF]: Data Rows Updated by Location Mapping 'Inc' (LIKE): 16

      2017-05-22 14:52:56,259 INFO  [AIF]:

      Processing Mappings for Column 'UD11'

      2017-05-22 14:52:56,261 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 16

      2017-05-22 14:52:56,263 INFO  [AIF]: Data Rows Updated by Location Mapping 'Agency' (LIKE): 0

      2017-05-22 14:52:56,263 INFO  [AIF]:

      Processing Mappings for Column 'UD2'

      2017-05-22 14:52:56,265 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 16

      2017-05-22 14:52:56,266 INFO  [AIF]: Data Rows Updated by Location Mapping 'Location' (LIKE): 0

      2017-05-22 14:52:56,266 INFO  [AIF]:

      Processing Mappings for Column 'UD3'

      2017-05-22 14:52:56,269 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 16

      2017-05-22 14:52:56,270 INFO  [AIF]: Data Rows Updated by Location Mapping 'Cost center' (LIKE): 0

      2017-05-22 14:52:56,270 INFO  [AIF]:

      Processing Mappings for Column 'UD6'

      2017-05-22 14:52:56,271 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,273 INFO  [AIF]: Data Rows Updated by Location Mapping 'LOB' (LIKE): 16

      2017-05-22 14:52:56,273 INFO  [AIF]:

      Processing Mappings for Column 'UD8'

      2017-05-22 14:52:56,274 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,276 INFO  [AIF]: Data Rows Updated by Location Mapping 'Project' (LIKE): 16

      2017-05-22 14:52:56,276 INFO  [AIF]:

      Processing Mappings for Column 'UD9'

      2017-05-22 14:52:56,277 INFO  [AIF]: Data Rows Updated by Location Mapping 'Asset_Detail' (LIKE): 16

      2017-05-22 14:52:56,282 INFO  [AIF]:

      Map Data for Period 'JUN-17'

      2017-05-22 14:52:56,285 INFO  [AIF]:

      Processing Mappings for Column 'ACCOUNT'

      2017-05-22 14:52:56,287 INFO  [AIF]: Data Rows Updated by Location Mapping 'Projects' (LIKE): 15

      2017-05-22 14:52:56,287 INFO  [AIF]:

      Processing Mappings for Column 'ENTITY'

      2017-05-22 14:52:56,288 INFO  [AIF]: Data Rows Updated by Location Mapping 'Ignore' (IN): 0

      2017-05-22 14:52:56,289 INFO  [AIF]: Data Rows Updated by Location Mapping 'Entity' (LIKE): 15

      2017-05-22 14:52:56,289 INFO  [AIF]:

      Processing Mappings for Column 'UD1'

      2017-05-22 14:52:56,290 INFO  [AIF]: Data Rows Updated by Location Mapping 'Active' (LIKE): 15

      2017-05-22 14:52:56,291 INFO  [AIF]:

      Processing Mappings for Column 'UD10'

      2017-05-22 14:52:56,292 INFO  [AIF]: Data Rows Updated by Location Mapping 'Inc' (LIKE): 15

      2017-05-22 14:52:56,292 INFO  [AIF]:

      Processing Mappings for Column 'UD11'

      2017-05-22 14:52:56,294 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 15

      2017-05-22 14:52:56,295 INFO  [AIF]: Data Rows Updated by Location Mapping 'Agency' (LIKE): 0

      2017-05-22 14:52:56,295 INFO  [AIF]:

      Processing Mappings for Column 'UD2'

      2017-05-22 14:52:56,297 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 15

      2017-05-22 14:52:56,298 INFO  [AIF]: Data Rows Updated by Location Mapping 'Location' (LIKE): 0

      2017-05-22 14:52:56,298 INFO  [AIF]:

      Processing Mappings for Column 'UD3'

      2017-05-22 14:52:56,299 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 15

      2017-05-22 14:52:56,300 INFO  [AIF]: Data Rows Updated by Location Mapping 'Cost center' (LIKE): 0

      2017-05-22 14:52:56,300 INFO  [AIF]:

      Processing Mappings for Column 'UD6'

      2017-05-22 14:52:56,301 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,303 INFO  [AIF]: Data Rows Updated by Location Mapping 'LOB' (LIKE): 15

      2017-05-22 14:52:56,303 INFO  [AIF]:

      Processing Mappings for Column 'UD8'

      2017-05-22 14:52:56,304 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,305 INFO  [AIF]: Data Rows Updated by Location Mapping 'Project' (LIKE): 15

      2017-05-22 14:52:56,305 INFO  [AIF]:

      Processing Mappings for Column 'UD9'

      2017-05-22 14:52:56,306 INFO  [AIF]: Data Rows Updated by Location Mapping 'Asset_Detail' (LIKE): 15

      2017-05-22 14:52:56,311 INFO  [AIF]:

      Map Data for Period 'JUL-17'

      2017-05-22 14:52:56,314 INFO  [AIF]:

      Processing Mappings for Column 'ACCOUNT'

      2017-05-22 14:52:56,315 INFO  [AIF]: Data Rows Updated by Location Mapping 'Projects' (LIKE): 14

      2017-05-22 14:52:56,315 INFO  [AIF]:

      Processing Mappings for Column 'ENTITY'

      2017-05-22 14:52:56,316 INFO  [AIF]: Data Rows Updated by Location Mapping 'Ignore' (IN): 0

      2017-05-22 14:52:56,317 INFO  [AIF]: Data Rows Updated by Location Mapping 'Entity' (LIKE): 14

      2017-05-22 14:52:56,317 INFO  [AIF]:

      Processing Mappings for Column 'UD1'

      2017-05-22 14:52:56,318 INFO  [AIF]: Data Rows Updated by Location Mapping 'Active' (LIKE): 14

      2017-05-22 14:52:56,318 INFO  [AIF]:

      Processing Mappings for Column 'UD10'

      2017-05-22 14:52:56,319 INFO  [AIF]: Data Rows Updated by Location Mapping 'Inc' (LIKE): 14

      2017-05-22 14:52:56,320 INFO  [AIF]:

      Processing Mappings for Column 'UD11'

      2017-05-22 14:52:56,321 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 14

      2017-05-22 14:52:56,322 INFO  [AIF]: Data Rows Updated by Location Mapping 'Agency' (LIKE): 0

      2017-05-22 14:52:56,322 INFO  [AIF]:

      Processing Mappings for Column 'UD2'

      2017-05-22 14:52:56,324 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 14

      2017-05-22 14:52:56,324 INFO  [AIF]: Data Rows Updated by Location Mapping 'Location' (LIKE): 0

      2017-05-22 14:52:56,324 INFO  [AIF]:

      Processing Mappings for Column 'UD3'

      2017-05-22 14:52:56,326 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 14

      2017-05-22 14:52:56,327 INFO  [AIF]: Data Rows Updated by Location Mapping 'Cost center' (LIKE): 0

      2017-05-22 14:52:56,327 INFO  [AIF]:

      Processing Mappings for Column 'UD6'

      2017-05-22 14:52:56,328 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,329 INFO  [AIF]: Data Rows Updated by Location Mapping 'LOB' (LIKE): 14

      2017-05-22 14:52:56,329 INFO  [AIF]:

      Processing Mappings for Column 'UD8'

      2017-05-22 14:52:56,330 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,331 INFO  [AIF]: Data Rows Updated by Location Mapping 'Project' (LIKE): 14

      2017-05-22 14:52:56,332 INFO  [AIF]:

      Processing Mappings for Column 'UD9'

      2017-05-22 14:52:56,333 INFO  [AIF]: Data Rows Updated by Location Mapping 'Asset_Detail' (LIKE): 14

      2017-05-22 14:52:56,337 INFO  [AIF]:

      Map Data for Period 'AUG-17'

      2017-05-22 14:52:56,340 INFO  [AIF]:

      Processing Mappings for Column 'ACCOUNT'

      2017-05-22 14:52:56,341 INFO  [AIF]: Data Rows Updated by Location Mapping 'Projects' (LIKE): 5

      2017-05-22 14:52:56,341 INFO  [AIF]:

      Processing Mappings for Column 'ENTITY'

      2017-05-22 14:52:56,342 INFO  [AIF]: Data Rows Updated by Location Mapping 'Ignore' (IN): 0

      2017-05-22 14:52:56,343 INFO  [AIF]: Data Rows Updated by Location Mapping 'Entity' (LIKE): 5

      2017-05-22 14:52:56,343 INFO  [AIF]:

      Processing Mappings for Column 'UD1'

      2017-05-22 14:52:56,344 INFO  [AIF]: Data Rows Updated by Location Mapping 'Active' (LIKE): 5

      2017-05-22 14:52:56,344 INFO  [AIF]:

      Processing Mappings for Column 'UD10'

      2017-05-22 14:52:56,345 INFO  [AIF]: Data Rows Updated by Location Mapping 'Inc' (LIKE): 5

      2017-05-22 14:52:56,345 INFO  [AIF]:

      Processing Mappings for Column 'UD11'

      2017-05-22 14:52:56,346 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 5

      2017-05-22 14:52:56,347 INFO  [AIF]: Data Rows Updated by Location Mapping 'Agency' (LIKE): 0

      2017-05-22 14:52:56,347 INFO  [AIF]:

      Processing Mappings for Column 'UD2'

      2017-05-22 14:52:56,349 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 5

      2017-05-22 14:52:56,349 INFO  [AIF]: Data Rows Updated by Location Mapping 'Location' (LIKE): 0

      2017-05-22 14:52:56,350 INFO  [AIF]:

      Processing Mappings for Column 'UD3'

      2017-05-22 14:52:56,351 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 5

      2017-05-22 14:52:56,352 INFO  [AIF]: Data Rows Updated by Location Mapping 'Cost center' (LIKE): 0

      2017-05-22 14:52:56,352 INFO  [AIF]:

      Processing Mappings for Column 'UD6'

      2017-05-22 14:52:56,353 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,354 INFO  [AIF]: Data Rows Updated by Location Mapping 'LOB' (LIKE): 5

      2017-05-22 14:52:56,354 INFO  [AIF]:

      Processing Mappings for Column 'UD8'

      2017-05-22 14:52:56,355 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,356 INFO  [AIF]: Data Rows Updated by Location Mapping 'Project' (LIKE): 5

      2017-05-22 14:52:56,356 INFO  [AIF]:

      Processing Mappings for Column 'UD9'

      2017-05-22 14:52:56,357 INFO  [AIF]: Data Rows Updated by Location Mapping 'Asset_Detail' (LIKE): 5

      2017-05-22 14:52:56,360 INFO  [AIF]:

      Map Data for Period 'SEP-17'

      2017-05-22 14:52:56,364 INFO  [AIF]:

      Processing Mappings for Column 'ACCOUNT'

      2017-05-22 14:52:56,364 INFO  [AIF]: Data Rows Updated by Location Mapping 'Projects' (LIKE): 1

      2017-05-22 14:52:56,365 INFO  [AIF]:

      Processing Mappings for Column 'ENTITY'

      2017-05-22 14:52:56,365 INFO  [AIF]: Data Rows Updated by Location Mapping 'Ignore' (IN): 0

      2017-05-22 14:52:56,366 INFO  [AIF]: Data Rows Updated by Location Mapping 'Entity' (LIKE): 1

      2017-05-22 14:52:56,366 INFO  [AIF]:

      Processing Mappings for Column 'UD1'

      2017-05-22 14:52:56,367 INFO  [AIF]: Data Rows Updated by Location Mapping 'Active' (LIKE): 1

      2017-05-22 14:52:56,367 INFO  [AIF]:

      Processing Mappings for Column 'UD10'

      2017-05-22 14:52:56,368 INFO  [AIF]: Data Rows Updated by Location Mapping 'Inc' (LIKE): 1

      2017-05-22 14:52:56,368 INFO  [AIF]:

      Processing Mappings for Column 'UD11'

      2017-05-22 14:52:56,369 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-05-22 14:52:56,370 INFO  [AIF]: Data Rows Updated by Location Mapping 'Agency' (LIKE): 0

      2017-05-22 14:52:56,370 INFO  [AIF]:

      Processing Mappings for Column 'UD2'

      2017-05-22 14:52:56,371 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-05-22 14:52:56,372 INFO  [AIF]: Data Rows Updated by Location Mapping 'Location' (LIKE): 0

      2017-05-22 14:52:56,372 INFO  [AIF]:

      Processing Mappings for Column 'UD3'

      2017-05-22 14:52:56,373 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-05-22 14:52:56,374 INFO  [AIF]: Data Rows Updated by Location Mapping 'Cost center' (LIKE): 0

      2017-05-22 14:52:56,374 INFO  [AIF]:

      Processing Mappings for Column 'UD6'

      2017-05-22 14:52:56,375 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,376 INFO  [AIF]: Data Rows Updated by Location Mapping 'LOB' (LIKE): 1

      2017-05-22 14:52:56,376 INFO  [AIF]:

      Processing Mappings for Column 'UD8'

      2017-05-22 14:52:56,377 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,378 INFO  [AIF]: Data Rows Updated by Location Mapping 'Project' (LIKE): 1

      2017-05-22 14:52:56,378 INFO  [AIF]:

      Processing Mappings for Column 'UD9'

      2017-05-22 14:52:56,379 INFO  [AIF]: Data Rows Updated by Location Mapping 'Asset_Detail' (LIKE): 1

      2017-05-22 14:52:56,382 INFO  [AIF]:

      Map Data for Period 'OCT-17'

      2017-05-22 14:52:56,386 WARN  [AIF]:

      Warning: Data rows with zero balances exist

      2017-05-22 14:52:56,386 INFO  [AIF]: Zero Balance Data Rows Deleted: 1

      2017-05-22 14:52:56,386 ERROR [AIF]: Error: No records exist for Period 'OCT-17'

      2017-05-22 14:52:56,408 FATAL [AIF]: Error in CommMap.updateTDATASEG_T_TDATASEGW

      Traceback (most recent call last):

        File "<string>", line 1729, in updateTDATASEG_T_TDATASEGW

      RuntimeError: Error: No records exist for Period 'OCT-17'

       

       

      2017-05-22 14:52:56,408 INFO  [AIF]:

      Map Data for Period 'NOV-17'

      2017-05-22 14:52:56,412 INFO  [AIF]:

      Processing Mappings for Column 'ACCOUNT'

      2017-05-22 14:52:56,413 INFO  [AIF]: Data Rows Updated by Location Mapping 'Projects' (LIKE): 1

      2017-05-22 14:52:56,413 INFO  [AIF]:

      Processing Mappings for Column 'ENTITY'

      2017-05-22 14:52:56,414 INFO  [AIF]: Data Rows Updated by Location Mapping 'Ignore' (IN): 0

      2017-05-22 14:52:56,415 INFO  [AIF]: Data Rows Updated by Location Mapping 'Entity' (LIKE): 1

      2017-05-22 14:52:56,415 INFO  [AIF]:

      Processing Mappings for Column 'UD1'

      2017-05-22 14:52:56,416 INFO  [AIF]: Data Rows Updated by Location Mapping 'Active' (LIKE): 1

      2017-05-22 14:52:56,416 INFO  [AIF]:

      Processing Mappings for Column 'UD10'

      2017-05-22 14:52:56,417 INFO  [AIF]: Data Rows Updated by Location Mapping 'Inc' (LIKE): 1

      2017-05-22 14:52:56,417 INFO  [AIF]:

      Processing Mappings for Column 'UD11'

      2017-05-22 14:52:56,418 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-05-22 14:52:56,419 INFO  [AIF]: Data Rows Updated by Location Mapping 'Agency' (LIKE): 0

      2017-05-22 14:52:56,419 INFO  [AIF]:

      Processing Mappings for Column 'UD2'

      2017-05-22 14:52:56,420 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-05-22 14:52:56,421 INFO  [AIF]: Data Rows Updated by Location Mapping 'Location' (LIKE): 0

      2017-05-22 14:52:56,421 INFO  [AIF]:

      Processing Mappings for Column 'UD3'

      2017-05-22 14:52:56,422 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 1

      2017-05-22 14:52:56,423 INFO  [AIF]: Data Rows Updated by Location Mapping 'Cost center' (LIKE): 0

      2017-05-22 14:52:56,423 INFO  [AIF]:

      Processing Mappings for Column 'UD6'

      2017-05-22 14:52:56,424 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,425 INFO  [AIF]: Data Rows Updated by Location Mapping 'LOB' (LIKE): 1

      2017-05-22 14:52:56,425 INFO  [AIF]:

      Processing Mappings for Column 'UD8'

      2017-05-22 14:52:56,426 INFO  [AIF]: Data Rows Updated by Location Mapping EXPLICIT: 0

      2017-05-22 14:52:56,427 INFO  [AIF]: Data Rows Updated by Location Mapping 'Project' (LIKE): 1

      2017-05-22 14:52:56,427 INFO  [AIF]:

      Processing Mappings for Column 'UD9'

      2017-05-22 14:52:56,428 INFO  [AIF]: Data Rows Updated by Location Mapping 'Asset_Detail' (LIKE): 1

      2017-05-22 14:52:56,431 INFO  [AIF]:

      Map Data for Period 'DEC-17'

      2017-05-22 14:52:56,434 WARN  [AIF]: Warning: No records exist for Period 'DEC-17'

      2017-05-22 14:52:56,437 FATAL [AIF]: Error in CommMap.updateTDATASEG_T_TDATASEGW

      Traceback (most recent call last):

        File "<string>", line 1973, in updateTDATASEG_T_TDATASEGW

      RuntimeError: [u"Error: No records exist for Period 'OCT-17'"]

       

       

      2017-05-22 14:52:57,513 FATAL [AIF]: Error in COMM Map Data

      2017-05-22 14:52:57,521 INFO  [AIF]: FDMEE Process End, Process ID: 634

       

      Please help !