topic How to export DI jobs containing deployed BRM rules in SAS Data Management

How to export DI jobs containing deployed BRM rules

Bipasha — Thu, 20 Jul 2017 15:42:01 GMT

Hi. I have a DI job which contains deployed BRM rule in it. I am trying to migrate this job to another environment having a similar structure. I am exporting this job with the rules associated with it from one environment and importing the same in the new environment. But jobs containing BRM rules are not working while other plain DI jobs are working properly.

Is there any specific process to export and import jobs with BRM rules?

If yes kindly provide the way.

Re: How to export DI jobs containing deployed BRM rules

RonAgresta — Fri, 21 Jul 2017 19:54:15 GMT

Hi,

Have you ensured that the business rules are also available in that second environment? The DI Studio log may give you more information about where the process is failing.

Ron

Re: How to export DI jobs containing deployed BRM rules

Bipasha — Sat, 22 Jul 2017 11:06:53 GMT

I am trying to export and import the rules using macros as mentioned in the BRM user guide. I am using the following macros:

%BRM_EXPORT_FOLDER

%BRM_EXPORT_LOOKUP

%BRM_EXPORT_RULE_FLOW

%BRM_EXPORT_RULESET

%BRM_EXPORT_VOCABULARY

%BRM_IMPORT_FOLDER

%BRM_IMPORT_LOOKUP

%BRM_IMPORT_RULE_FLOW

%BRM_IMPORT_RULESET

%BRM_IMPORT_VOCABULARY

There are two(%BRM_CREATE_TEMP_TERM, %BRM_LOAD_VOCABULARY) more macros mentioned which I am not using for now.

I can export the components properly, but cannot import it into the new environment. I am using the following codes to import:

%BRM_IMPORT_FOLDER (CSV=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/BRMFOLDER.CSV),REJECT=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/REJECT_FOLDER.CSV));
%BRM_IMPORT_LOOKUP (CSV=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/BRMLOOKUP.CSV),REJECT=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/REJECT_LOOKUP.CSV));
%BRM_IMPORT_RULE_FLOW (RULEFLOWS=ALL,CSV=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/BRMRULLFLOW.CSV),REJECT=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/REJECT_RULFLOW.CSV));
%BRM_IMPORT_RULESET (RULESETS=ALL,CSV=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/BRMRULESET.CSV),REJECT=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/REJECT_RULESET.CSV));
%BRM_IMPORT_VOCABULARY (VOCAB=ALL,CSV=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/BRVOCABULARY.CSV),REJECT=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/REJECT_VOCAB.CSV));

But this code throws the following error:

ERROR: Invalid connection options. Lack USER option.
ERROR: Error in the LIBNAME statement.

ERROR: Cannot access database.

I am not sure if these errors are for the BRM import process or something wrong in the configuration. I can run simple programs with the same server connection.

Can any body point me where I am going wrong?

Re: How to export DI jobs containing deployed BRM rules

Patrick — Sun, 23 Jul 2017 04:13:22 GMT

@Bipasha

The error pretty clearly indicates that you haven't been successful in migrating your rules yet.

The error is also pretty clear that something with your connetion option isn't working.

Have a chat with your SAS Admin/the person who's done the environment configuration.

Also: Run your code with option mprint set so you'll get a bit more log information.

Eventually also use options sastrace=',,,d' sastraceloc=saslog nostsuffix; to get a bit more log info how SAS interacts with the BRM database. Given your current error you're not even there yet as you can't establish a connection.

Re: How to export DI jobs containing deployed BRM rules

Bipasha — Sun, 23 Jul 2017 16:01:12 GMT

Thank you for your suggestions.

It turns out that the user I was using was not a member of the SAS decision manager group. Once I corrected that other issues were easy to solve.