Error logs troubleshooting tips

Allocation Setup logs are shown on the right pane of the Allocation Setup page. The logs give a report of invalid rules and metric weight maps, and invalid accounts because of which amount could not be allocated. This helps you to troubleshoot the errors.

Table 1. Error logs and resolution
Error/warning type Error Description Possible causes and resolution
Bucket Data Validation Bucket Data Validation: <bucket> is Ignored: true/false, but one of its children is: false/true <bucket> ignored flag does not match with its parent Make sure the ignored flag of bucket and its parent are the same in itfm_bucket table for the <bucket>
Bucket Allocation Bucket Allocation: <bucket> with no allocate_to_txn_segment, which is mandatory <bucket> with an allocation rule has no 'Allocate to segment' Delete the allocation rule in itfm_bucket_allocation_rule table for <bucket> and recreate the bucket allocation using workbench
Bucket Allocation Bucket Allocation: '<bucket>' with invalid allocate_to_txn_segment <bucket> with an allocation rule has invalid 'Allocate to segment' Delete the allocation rule in itfm_bucket_allocation_rule table for <bucket> and recreate the bucket allocation using workbench
Bucket Allocation Bucket Allocation: '<bucket>' allocation is use-metric, but no metric attached <bucket> with weighted metric based allocation rule has no metric attached Delete the allocation rule in itfm_bucket_allocation_rule table for <bucket> and recreate the bucket allocation using workbench
Bucket Allocation Bucket Allocation: '<bucket>' allocation is use-metric, but invalid metric <bucket> with weighted metric based allocation rule has invalid metric attached Delete the allocation rule in itfm_bucket_allocation_rule table for <bucket> and recreate the bucket allocation using workbench
Bucket Allocation Bucket Allocation: '<bucket>' allocation with no allocate_to_txn_account which is mandatory for all-in type <bucket> with an allocation rule has no 'Allocate to account' with allocation type as 'All-in' Delete the allocation rule in itfm_bucket_allocation_rule table for <bucket> and recreate the bucket allocation using workbench
Bucket Allocation Bucket Allocation: '<bucket>' allocation (all-in) is to invalid Account: <account> (<segment>) <bucket> with an allocation rule has invalid 'Allocate to account' with allocation type as 'All-in' Delete the allocation rule in itfm_bucket_allocation_rule table for <bucket> and recreate the bucket allocation using workbench
Bucket Allocation Bucket Allocation: '<bucket>' allocation manually divided with no txn_segment or txn_account or percent, which is mandatory Manually divided <bucket> with an allocation account has no 'Allocate to account' or 'Allocate to segment' or percent which are mandatory with allocation type as 'Manually Divided'

Delete the allocation rule in itfm_bucket_allocation_rule table for <bucket> and recreate the bucket allocation using workbench

Delete the bucket related records in itfm_bucket_allocation_account table for <bucket>

Recreate the bucket allocation using workbench

Bucket Allocation Bucket Allocation: '<bucket>' allocation manually divided is to invalid Segment: '<segment>' Manually divided <bucket> with an allocation account has no/invalid 'Allocate to segment'

Delete the allocation rule in itfm_bucket_allocation_rule table for <bucket> and recreate the bucket allocation using workbench

Delete the bucket related records in itfm_bucket_allocation_account table for <bucket>

Recreate the bucket allocation using workbench

Bucket Allocation Bucket Allocation: '<bucket>' allocation manually divided is to invalid Account: <account> (<segment>). <percent>% amount will be lost Manually divided <bucket> with an allocation account has no/invalid 'Allocate to account' which loses some percent of amount

Delete the allocation rule in itfm_bucket_allocation_rule table for <bucket> and recreate the bucket allocation using workbench

Delete the bucket related records in itfm_bucket_allocation_account table for <bucket>

Recreate the bucket allocation using workbench

Bucket Allocation Bucket Allocation: '<bucket>':- Sum of the manual percentages is <percent> which is more than 100 Manually divided <bucket> with allocation accounts has sum of percentages which is more than 100

Delete the allocation rule in itfm_bucket_allocation_rule table for <bucket> and recreate the bucket allocation using workbench

Delete the bucket related records in itfm_bucket_allocation_account table for <bucket>

Recreate the bucket allocation using workbench

Bucket Allocation Bucket Allocation: '<bucket>':- Sum of the manual percentages is <percent> which is less than 100 Manually divided <bucket> with allocation accounts has sum of percentages which is less than 100

Delete the allocation rule in itfm_bucket_allocation_rule table for <bucket> and recreate the bucket allocation using workbench

Delete the bucket related records in itfm_bucket_allocation_account table for <bucket>

Recreate the bucket allocation using workbench

Bucket Allocation Bucket Allocation: '<bucket>' allocation is manually divided, but not allocated to any accounts Manually divided <bucket> with no allocation accounts

Delete the allocation rule in itfm_bucket_allocation_rule table for <bucket> and recreate the bucket allocation using workbench

Delete the bucket related records in itfm_bucket_allocation_account table for <bucket>

Recreate the bucket allocation using workbench

Segment Rollup Segment Rollup: '<rollup name>': From txn Segment does not exist Segment Rollup <rollup name> has no from_txn_segment

Delete rollup rule with <rollup name> in itfm_rollup table

Recreate the rollup again using workbench

Segment Rollup Segment Rollup: '<rollup name>': From txn Segment is invalid: <sys_id> Segment Rollup <rollup name> has invalid sys_id in from_txn_segment

Delete rollup rule with <rollup name> in itfm_rollup table

Recreate the rollup again using workbench

Segment Rollup Segment Rollup: '<rollup name>': To txn Segment does not exist Segment Rollup <rollup name> has no to_txn_segment

Delete rollup rule with <rollup name> in itfm_rollup table

Recreate the rollup again using workbench

Segment Rollup Segment Rollup: '<rollup name>': To txn Segment is invalid: <sys_id> Segment Rollup <rollup name> has invalid sys_id in to_txn_segment

Delete rollup rule with <rollup name> in itfm_rollup table

Recreate the rollup again using workbench

Segment Rollup Segment Rollup: '<rollup name>': rollup is use-metric with no metric id Segment Rollup <rollup name> has no metric reference in rollup_using_metric

Delete rollup rule with <rollup name> in itfm_rollup table

Recreate the rollup again using workbench

Segment Rollup Segment Rollup: '<rollup name>' rollup is with invalid metric: <sys_id> Segment Rollup <rollup name> has invalid metric reference in rollup_using_metric

Delete rollup rule with <rollup name> in itfm_rollup table

Recreate the rollup again using workbench

Account Rollup Account Rollup: '<rollup name>': From txn Segment does not exist Account Rollup <rollup name> has no from_txn_segment

Delete rollup rule with <rollup name> in itfm_rollup_override table

Recreate the rollup again using workbench

Account Rollup Account Rollup: '<rollup name>': From txn Segment: <sys_id> is invalid Account Rollup <rollup name> has invalid from_txn_segment

Delete rollup rule with <rollup name> in itfm_rollup_override table

Recreate the rollup again using workbench

Account Rollup Account Rollup: '<rollup name>': To txn Segment does not exist Account Rollup <rollup name> has no to_txn_segment

Delete rollup rule with <rollup name> in itfm_rollup_override table

Recreate the rollup again using workbench

Account Rollup Account Rollup: '<rollup name>': To txn Segment: <sys_id> is invalid Account Rollup <rollup name> has invalid to_txn_segment

Delete rollup rule with <rollup name> in itfm_rollup_override table

Recreate the rollup again using workbench

Account Rollup Account Rollup: '<rollup name>': rollup override is use-metric with no metric id Account Rollup <rollup name> has no metric in rollup_using_metric

Delete rollup rule with <rollup name> in itfm_rollup_override table

Recreate the rollup again using workbench

Account Rollup Account Rollup: '<rollup name>' rollup override has invalid metric: <sys_id> Account Rollup <rollup name> has invalid metric in rollup_using_metric

Delete rollup rule with <rollup name> in itfm_rollup_override table

Recreate the rollup again using workbench

Account Rollup Account Rollup: '<rollup name>': From txn Account does not exist Account Rollup <rollup name> has no from_txn_account

Delete rollup rule with <rollup name> in itfm_rollup_override table

Recreate the rollup again using workbench

Account Rollup Account Rollup: '<rollup name>': From txn Account: <account/sys_id> (<segment>) is invalid Account Rollup <rollup name> has invalid from_txn_account

Delete rollup rule with <rollup name> in itfm_rollup_override table

Recreate the rollup again using workbench

Account Rollup Account Rollup: 'rollup name': To txn Account does not exist Account Rollup <rollup name> has no to_txn_account

Delete rollup rule with <rollup name> in itfm_rollup_override table

Recreate the rollup again using workbench

Account Rollup Account Rollup: '<rollup name>': To txn Account: <account> (<segment>) is invalid Account Rollup <rollup name> has invalid to_txn_account

Delete rollup rule with <rollup name> in itfm_rollup_override table

Recreate the rollup again using workbench

Account Rollup Account Rollup: '<rollup name>' rollup override is manually divided with no/invalid percent value Account Rollup <rollup name> has no/invalid percent

Delete rollup rule with <rollup name> in itfm_rollup_override table

Recreate the rollup again using workbench

Account Rollup Account Rollup: '<rollup name>' rollup override is manually divided with percent value more than 100 Manually divided rollup override <rollup name> with accounts has sum of percentages which is more than 100

Delete rollup rules with <rollup name> in itfm_rollup_override table

Recreate the rollup again using workbench

Account Rollup Account Rollup: '<rollup name>' rollup override is manually divided with percent value less than 100 Manually divided rollup override <rollup name> with accounts has sum of percentages which is less than 100

Delete rollup rules with <rollup name> in itfm_rollup_override table

Recreate the rollup again using workbench

Account Rollup <rollup name>: No weight map exists for the metric '<metric>' in fiscal period <fiscal period> No weight map exists for the <metric> attached to rollup/override in the fiscal period

Check if the Weight Table is loaded

Generate weight map for the fiscal period using generate weight map in Metric for that fiscal period

Check the fiscal validity of the Segments used in the Metric

Account Rollup <rollup name>: Invalid account: <account>(<segment>) in weight map for the metric '<metric>' in fiscal period <fiscal period>. <percent>% amount will be lost Invalid account in the weight map of the <metric> for the fiscal period and the percent of amount loses Check the fiscal validity of the Segments used in the Metric