If you access the SAS Strategy Management Manage Forms page in SAS Strategy Management Builder, you might encounter the following error:

When you encounter this problem, no forms are displayed when you click OK in the message dialog box. In addition, the Strategy Management log.txt log in the SAS-configuration-directory\Lev1\Web\Logs\SASStrategyManagement5.x directory includes an error similar to this:

This error occurs if a data-entry form owner has been removed from the system. For example, any SAS Strategy Management user who accesses the Manage Forms page encounters the Error Retrieving Data problem if a SAS administrator has logged in to SAS^® Management Console, selected the User Manager plug-in, and deleted a user who is an owner of a SAS Strategy Management data-entry form.

If you are using SAS Strategy Management release 5.4, you can contact SAS Technical Support to request the FixFormOwner.sas program, which you can execute to resolve this issue.

FixFormOwner.sas Program

This section provides a brief overview of the FixFormOwner.sas program. See the comments section of the FixFormOwner.sas program for complete instructions.

When the FixFormOwner.sas program runs, it updates each data-entry form whose owner is no longer defined in the metadata with a new owner. The new owner is the project owner. If all data-entry forms have owners who are defined, then no changes are made.

1. After you receive the FixFormOwner.sas program from SAS Technical Support, open it in Notepad or another text editor. Notice that it includes the following OPTIONS statement:
   /* connection information to metadata server. */ options metaserver=yourMetadataserver metaport=8561 metarepository=Foundation metauser=trusteduserid metapass=password;
2. You must modify the OPTIONS statement and provide valid parameters for your SAS environment. An example is shown here:
   /* connection information to metadata server. */ options metaserver=SASBI.demo.sas.com metaport=8561 metarepository=Foundation metauser='sastrust@saspw' metapass=Orion123;
3. After you have updated the FixFormOwner.sas code for your environment, you need to run it. You can copy the updated code to Base SAS^®, SAS^® Data Integration Studio, or SAS^® Enterprise Guide^® if you want to run it in one of those applications. Or, you can right-click the file, and select Batch Submit with SAS 9.3, as shown here:
   
   
   
   
4. If you run the program by selecting Batch Submit with SAS 9.3, then the folder where it ran includes a FixFormOwner text file, as shown here. The folder also includes log information, including any forms whose owner was changed.
   
   
   
   If you run the SAS code in a SAS application, then open its log window to get this information.



5. The FixFormOwner log informs you if a change was made to a form's owner. In the following snippet copied from a FixFormOwner log, the sasdemo user replaced the sasdemo1 user as owner of the form named DataEntryForm2 in the project named StM_ProjectA:
   Info: form id 04eb5270-0a26-0b33-6523-ff4a6dddc07c (DataEntryForm2) has an invalid ownerid of sasdemo1, changing to project owner of sasdemo. Project id is 37f00889-0a26-0c38-58d7-598532f736e7 (StM_ProjectA).

After the program successfully runs, you should be able to access the Manage Forms page without encountering the error shown above:

Operating System and Release Information