Bamboo does not export brs.queue_time and brs.variable_context_baseline_id

Problem

• Bamboo does not import data from Export generated:
  • BUILDRESULTSUMMARY.TRIGGER_REASON
  • BUILDRESULTSUMMARY.QUEUE_TIME
  • BUILDRESULTSUMMARY.VARIABLE_CONTEXT_BASELINE_ID
  • BUILDRESULTSUMMARY.VCS_UPDATE_TIME
  • DEPLOYMENT_VERSION.VARIABLE_CONTEXT_BASELINE_ID

Replicate

1. install Bamboo v5.10.0
2. create project / plan
3. create plan variables:

   Variable name	Value
   major	1
   minor	3
   patch	7

4. add Script task

   echo "bamboo.major : ${bamboo.major}"
   echo "bamboo.minor : ${bamboo.minor}"
   echo "bamboo.patch : ${bamboo.patch}"
   
   echo "bamboo.major : ${bamboo.major}" \
    "bamboo.minor : ${bamboo.minor}" \
    "bamboo.patch : ${bamboo.patch}" >> "${bamboo.planKey}-${bamboo.buildNumber}.txt"
   

5. add Artifact definition

   Name	TextFile
   Location
   Copy pattern	*.txt

6. create Deployment to consume artifact generated and print Plan variables
7. run build and deployment
8. run Export in Bamboo v5.10.0
9. install Bamboo v5.10.2 using export from previous step
10. run database dump on both databases (Bamboo v5.10.0 and Bamboo v5.10.2)
11. run diff on two exports
    BUILDRESULTSUMMARY

    < INSERT INTO BUILDRESULTSUMMARY (BUILDRESULTSUMMARY_ID, BUILD_TYPE, CREATED_DATE, UPDATED_DATE, BUILD_KEY, BUILD_NUMBER, BUILD_STATE, LIFE_CYCLE_STATE, BUILD_DATE, BUILD_CANCELLED_DATE, BUILD_COMPLETED_DATE, DURATION, PROCESSING_DURATION, TIME_TO_FIX, TRIGGER_REASON, DELTA_STATE, BUILD_AGENT_ID, STAGERESULT_ID, RESTART_COUNT, QUEUE_TIME, MARKED_FOR_DELETION, ONCE_OFF, CUSTOM_BUILD, REBUILD, LOG_SIZE, VARIABLE_CONTEXT_BASELINE_ID, FORMAT_VERSION, FAILURE_TEST_COUNT, SUCCESS_TEST_COUNT, TOTAL_TEST_COUNT, BROKEN_TEST_COUNT, EXISTING_TEST_COUNT, FIXED_TEST_COUNT, TOTAL_TEST_DURATION, QUARANTINED_TEST_COUNT, SKIPPED_TEST_COUNT, VCS_UPDATE_TIME, CHAIN_RESULT, CONTINUABLE, FIXED_IN_RESULT, MERGERESULT_ID) VALUES (819201, 'CHAIN', '2016-03-16 17:24:29', '2016-03-16 17:24:36', 'PROJ-PLAN', 1, 'Successful', 'Finished', '2016-03-16 17:24:30', null, '2016-03-16 17:24:35', 5203, 5000, null, 'com.atlassian.bamboo.plugin.system.triggerReason:ManualBuildTriggerReason', 'NONE', null, null, 0, '2016-03-16 17:24:29', false, false, false, false, null, 753665, 51017, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, null, false, null, null);
    ---
    > INSERT INTO BUILDRESULTSUMMARY (BUILDRESULTSUMMARY_ID, BUILD_TYPE, CREATED_DATE, UPDATED_DATE, BUILD_KEY, BUILD_NUMBER, BUILD_STATE, LIFE_CYCLE_STATE, BUILD_DATE, BUILD_CANCELLED_DATE, BUILD_COMPLETED_DATE, DURATION, PROCESSING_DURATION, TIME_TO_FIX, TRIGGER_REASON, DELTA_STATE, BUILD_AGENT_ID, STAGERESULT_ID, RESTART_COUNT, QUEUE_TIME, MARKED_FOR_DELETION, ONCE_OFF, CUSTOM_BUILD, REBUILD, LOG_SIZE, VARIABLE_CONTEXT_BASELINE_ID, FORMAT_VERSION, FAILURE_TEST_COUNT, SUCCESS_TEST_COUNT, TOTAL_TEST_COUNT, BROKEN_TEST_COUNT, EXISTING_TEST_COUNT, FIXED_TEST_COUNT, TOTAL_TEST_DURATION, QUARANTINED_TEST_COUNT, SKIPPED_TEST_COUNT, VCS_UPDATE_TIME, CHAIN_RESULT, CONTINUABLE, FIXED_IN_RESULT, MERGERESULT_ID) VALUES (819201, 'CHAIN', '2016-03-16 17:24:29', '2016-03-16 17:24:36', 'PROJ-PLAN', 1, 'Successful', 'Finished', '2016-03-16 17:24:30', null, '2016-03-16 17:24:35', 5203, 5000, null, 'com.atlassian.bamboo.plugin.system.triggerReason:ManualBuildTriggerReason', 'NONE', null, null, 0, null, false, false, false, false, null, null, 51017, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, null, false, null, null);
    

    Bamboo version	QUEUE_TIME	VARIABLE_CONTEXT_BASELINE_ID
    v5.10.0	2016-03-16 17:24:29	753665
    v5.10.2	null	null

    BUILDRESULTSUMMARY

    < INSERT INTO BUILDRESULTSUMMARY (BUILDRESULTSUMMARY_ID, BUILD_TYPE, CREATED_DATE, UPDATED_DATE, BUILD_KEY, BUILD_NUMBER, BUILD_STATE, LIFE_CYCLE_STATE, BUILD_DATE, BUILD_CANCELLED_DATE, BUILD_COMPLETED_DATE, DURATION, PROCESSING_DURATION, TIME_TO_FIX, TRIGGER_REASON, DELTA_STATE, BUILD_AGENT_ID, STAGERESULT_ID, RESTART_COUNT, QUEUE_TIME, MARKED_FOR_DELETION, ONCE_OFF, CUSTOM_BUILD, REBUILD, LOG_SIZE, VARIABLE_CONTEXT_BASELINE_ID, FORMAT_VERSION, FAILURE_TEST_COUNT, SUCCESS_TEST_COUNT, TOTAL_TEST_COUNT, BROKEN_TEST_COUNT, EXISTING_TEST_COUNT, FIXED_TEST_COUNT, TOTAL_TEST_DURATION, QUARANTINED_TEST_COUNT, SKIPPED_TEST_COUNT, VCS_UPDATE_TIME, CHAIN_RESULT, CONTINUABLE, FIXED_IN_RESULT, MERGERESULT_ID) VALUES (819202, 'BUILD', '2016-03-16 17:24:30', '2016-03-16 17:24:35', 'PROJ-PLAN-JOB1', 1, 'Successful', 'Finished', '2016-03-16 17:24:31', null, '2016-03-16 17:24:34', 2359, 2359, null, 'com.atlassian.bamboo.plugin.system.triggerReason:ManualBuildTriggerReason', 'NONE', 163841, 884737, 0, '2016-03-16 17:24:29', false, false, false, false, null, 753665, 51017, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2016-03-16 17:24:30', 819201, null, null, null);
    ---
    > INSERT INTO BUILDRESULTSUMMARY (BUILDRESULTSUMMARY_ID, BUILD_TYPE, CREATED_DATE, UPDATED_DATE, BUILD_KEY, BUILD_NUMBER, BUILD_STATE, LIFE_CYCLE_STATE, BUILD_DATE, BUILD_CANCELLED_DATE, BUILD_COMPLETED_DATE, DURATION, PROCESSING_DURATION, TIME_TO_FIX, TRIGGER_REASON, DELTA_STATE, BUILD_AGENT_ID, STAGERESULT_ID, RESTART_COUNT, QUEUE_TIME, MARKED_FOR_DELETION, ONCE_OFF, CUSTOM_BUILD, REBUILD, LOG_SIZE, VARIABLE_CONTEXT_BASELINE_ID, FORMAT_VERSION, FAILURE_TEST_COUNT, SUCCESS_TEST_COUNT, TOTAL_TEST_COUNT, BROKEN_TEST_COUNT, EXISTING_TEST_COUNT, FIXED_TEST_COUNT, TOTAL_TEST_DURATION, QUARANTINED_TEST_COUNT, SKIPPED_TEST_COUNT, VCS_UPDATE_TIME, CHAIN_RESULT, CONTINUABLE, FIXED_IN_RESULT, MERGERESULT_ID) VALUES (819202, 'BUILD', '2016-03-16 17:24:30', '2016-03-16 17:24:35', 'PROJ-PLAN-JOB1', 1, 'Successful', 'Finished', '2016-03-16 17:24:31', null, '2016-03-16 17:24:34', 2359, 2359, null, null, 'NONE', 163841, 884737, 0, null, false, false, false, false, null, null, 51017, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, 819201, null, null, null);
    

    Bamboo version	TRIGGER_REASON	QUEUE_TIME	VARIABLE_CONTEXT_BASELINE_ID	VCS_UPDATE_TIME
    v5.10.0	com.atlassian.bamboo.plugin.system.triggerReason:ManualBuildTriggerReason	2016-03-16 17:24:29	753665	2016-03-16 17:24:30
    v5.10.2	null	null	null	null

    DEPLOYMENT_VERSION

    < INSERT INTO DEPLOYMENT_VERSION (DEPLOYMENT_VERSION_ID, NAME, CREATED_DATE, AGE_ZERO_POINT, CREATOR_USERNAME, PLAN_BRANCH_NAME, PROJECT_ID, VARIABLE_CONTEXT_BASELINE_ID) VALUES (983041, 'PROJ-PLAN-1-release-1', '2016-03-16 17:25:12', '2016-03-16 17:25:25', 'admin', 'master', 589825, 753665);
    ---
    > INSERT INTO DEPLOYMENT_VERSION (DEPLOYMENT_VERSION_ID, NAME, CREATED_DATE, AGE_ZERO_POINT, CREATOR_USERNAME, PLAN_BRANCH_NAME, PROJECT_ID, VARIABLE_CONTEXT_BASELINE_ID) VALUES (983041, 'PROJ-PLAN-1-release-1', '2016-03-16 17:25:12', '2016-03-16 17:25:25', 'admin', 'master', 589825, null);
    

    Bamboo version	VARIABLE_CONTEXT_BASELINE_ID
    v5.10.0	753665
    v5.10.2	null

Resulting on

• It is required to run a new build in order to have the variables available