Architecting, installing and maintaining your SAS environment

Json is not updating DBRT backup config

Accepted Solution Solved
Reply
Contributor
Posts: 35
Accepted Solution

Json is not updating DBRT backup config

Hi All ,

 

Currently the DBRT backup is including the database backup that I want to disable for Web Infrastructure Platform Data Server 9.4 using Json file

 

Current config

 

                  id:     4
                                name:   Web Infrastructure Platform Data Server 9.4
                                sasTierId:      tier3
                                included:       true

 

Json file content

 

{
  "name": "Web Infrastructure Platform Data Server 9.4",
  "sasTierId": "tier3",
  "included": false
 
}

 

 

Executed below command using the Json file. It is not updating the config and showing the below message.

 

Command Executed

./sas-update-backup-config -profile /app/sas/config/Lev2/Backup/Lev2.properties -sourcetype database -inputdata /app/sas/config/Lev2/Backup/ExcludeWIP.json
sas-update-backup-config
        statusCode:     404
        errorMessage:   User provided configuration already exist for given resource.
        remedyMessage:  You can update the existing resource with sas-update-backup-config.

The json output is written to the file: /app/sas/sashome/SASPlatformObjectFramework/9.4/tools/admin/sas-update-backup-config.json

 

Please help me in getting this resolved.

 

Thanks,
Sampath

 

 


Accepted Solutions
Solution
‎05-09-2018 10:24 AM
Trusted Advisor
Posts: 1,746

Re: Json is not updating DBRT backup config

Posted in reply to bmsampath

Hello @bmsampath,

 

first of all I would like to say: very interesting question, to investigate it it made me to learn something as well. Let me share it with you.

 

I would also like to say that the subject could be more indicative if, instead of DBRT it would say something as Backup Tool. My first impression (and second and third) when I read this subject is "what isDBRT?". Perhaps you would receive more answers by changing it.

 

Coming back to your question:

 

  • the JSON file for the update configuration is a filter. This concept is very important as per below.
  • The message you receive is because you are trying to add additional filters over the same configuration object.
  • Hence, the first thing we can conclude is that you already have a configuration filter, You would need to delete it.
  • You can delete filters as indicated in this link http://documentation.sas.com/?docsetId=bisag&docsetTarget=n0khpcet4rb0syn191i08w765cw1.htm&docsetVer...
  • Once you delete the filter, you can add a new one.
  • After everychange, I would recommed you to run a sas-display-backup-config command, to ensure the configuration is as you expect.

 

I have to say, that the policies applied by filters, it is a very clever one, since it would allow to change it right away, I would foresee a lot of corrupted configurations, especially regarding the WIP database, since we would miss to re-apply the configuration for the different internal databases, as SharedServices.

 

Thumbs up for the creator of this tool and the idea of including the filters.

 

Hope it helps,

 

Kind regards,

Juan

 

View solution in original post


All Replies
Solution
‎05-09-2018 10:24 AM
Trusted Advisor
Posts: 1,746

Re: Json is not updating DBRT backup config

Posted in reply to bmsampath

Hello @bmsampath,

 

first of all I would like to say: very interesting question, to investigate it it made me to learn something as well. Let me share it with you.

 

I would also like to say that the subject could be more indicative if, instead of DBRT it would say something as Backup Tool. My first impression (and second and third) when I read this subject is "what isDBRT?". Perhaps you would receive more answers by changing it.

 

Coming back to your question:

 

  • the JSON file for the update configuration is a filter. This concept is very important as per below.
  • The message you receive is because you are trying to add additional filters over the same configuration object.
  • Hence, the first thing we can conclude is that you already have a configuration filter, You would need to delete it.
  • You can delete filters as indicated in this link http://documentation.sas.com/?docsetId=bisag&docsetTarget=n0khpcet4rb0syn191i08w765cw1.htm&docsetVer...
  • Once you delete the filter, you can add a new one.
  • After everychange, I would recommed you to run a sas-display-backup-config command, to ensure the configuration is as you expect.

 

I have to say, that the policies applied by filters, it is a very clever one, since it would allow to change it right away, I would foresee a lot of corrupted configurations, especially regarding the WIP database, since we would miss to re-apply the configuration for the different internal databases, as SharedServices.

 

Thumbs up for the creator of this tool and the idea of including the filters.

 

Hope it helps,

 

Kind regards,

Juan

 

Contributor
Posts: 35

Re: Json is not updating DBRT backup config

[ Edited ]
Posted in reply to JuanS_OCS

Thanks a lot @JuanS_OCS. Your info has helped me to fix this issues. Thanks.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 216 views
  • 2 likes
  • 2 in conversation