SUPPORT / SAMPLES & SAS NOTES
 

Support

Installation Note 58132: When single sign-on is enabled, SAS® Business Data Network 3.1 workflow actions fail and a Workflow Error dialog box appears

DetailsHotfixAboutRate It

When you use SAS Business Data Network 3.1 with single sign-on enabled, an error occurs when you complete the following actions:

  1. You log on to SAS Business Data Network 3.1 using Integrated Windows Authentication (IWA) that is configured with Kerberos Delegation.
  2. You attempt to submit or publish in a workflow.

In this scenario, the following error appears in a dialog box:

SAS Business Data Network 3.1 error that occurs when you click Publish

Click the Hot Fix tab in this note to access the hot fix for this issue.

Change Your Workflows to Use a Different Number of Passwords

After you install this hot fix, workflows that have been modified to make up to five representational state transfer (REST) calls per workflow transition will run successfully. The default workflow templates use no more than two REST calls per transition. If you need more than five REST calls per transition, you can change your workflows to use a different number of passwords.

Tips for Setting Passwords

For information about how to change the number of passwords in your workflow, see the "Working with Data Objects" section in the SAS® Workflow Studio 1.3 User's Guide. You should also be able to access this documentation through the Help menu in SAS Workflow Studio. Some tips to help you with this process are detailed below:

  • Verify that passwords generated for each workflow transition use keys that conform to the following format:
    ${../BDN REST Password} ${../BDN REST Password 2} ${../BDN REST Password 3}
  • Label the data objects for the additional passwords using the following format:
    BDN Rest Password 6 BDN Rest Password 7
  • Select Short Text for the data object type and leave the rest of the fields blank.
  • Change all of your SAS Business Data Network workflows to have the same number of passwords and the same number of associated data objects when you change the number of passwords in your workflow.
  • Redeploy the adjusted workflows after you make these types of changes.

Implement the Adjusted Workflows

After you have changed the number of passwords and associated data objects, complete the following steps:

  1. Go to the location of your sas.dm.businessdata.war file, which is typically stored in Config\Lev1\Web\WebAppServer\SASServer13_1\sas_webapps\sas.dm.businessdata.war.
  2. Find and make a backup copy of the sas.dm.businessdata.server JAR file, which is stored inside the sas.dm.businessdata.war archive file that is located in WEB-INF\lib\sas.svcs.dm.businessdata.server-301001.0.0.20160414144734_f0bdn31p.jar.

    Note: The timestamp on your JAR file might be different.

  3. Open the META-INF\businessdata-config.xml file inside that JAR file.
  4. Edit the value for the password count property in the file. The default entry for the password count property looks like this:
  5. <bean id="workflowPasswordCount" class="com.sas.svcs.dm.workflow.server.util.WorkflowPasswordCount"> <property name="count"> <value type="java.lang.Integer">5</value> </property> </bean>
  6. Restart the SASServer13_1 service.


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Business Data NetworkMicrosoft® Windows® for x643.13.19.4 TS1M39.4 TS1M3
64-bit Enabled AIX3.13.19.4 TS1M39.4 TS1M3
64-bit Enabled Solaris3.13.19.4 TS1M39.4 TS1M3
HP-UX IPF3.13.19.4 TS1M39.4 TS1M3
Linux for x643.13.19.4 TS1M39.4 TS1M3
Solaris for x643.13.19.4 TS1M39.4 TS1M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.