SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How to export DI jobs containing deployed BRM rules

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 15
Accepted Solution

How to export DI jobs containing deployed BRM rules

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.


Accepted Solutions
Solution
‎07-23-2017 12:01 PM
Occasional Contributor
Posts: 15

Re: How to export DI jobs containing deployed BRM rules

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.

View solution in original post


All Replies
SAS Super FREQ
Posts: 97

Re: How to export DI jobs containing deployed BRM rules

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

Occasional Contributor
Posts: 15

Re: How to export DI jobs containing deployed BRM rules

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?

Respected Advisor
Posts: 4,173

Re: How to export DI jobs containing deployed BRM rules

@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.

Solution
‎07-23-2017 12:01 PM
Occasional Contributor
Posts: 15

Re: How to export DI jobs containing deployed BRM rules

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.

☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 625 views
  • 2 likes
  • 3 in conversation