topic Re: Can't export SAS Customer Intelligence in SAS Customer Intelligence

Can't export SAS Customer Intelligence

Asma_Manai — Thu, 29 Mar 2018 17:06:40 GMT

Hi I am using sas customer Intelligence to create some campaigns,

I'am connected with a user named usera

I need to export the target in a directory (linux) named /ftpdtm/MAexport

The user usera is the owner of the directory /ftpdtm/MAexport, still I can't export into the directory :

[MAEXPFIL].SYSERRORTEXT=[Insufficient authorization to access /ftpdtm/ExportMA//Target_20180329.]
at com.sas.analytics.crm.flow.FlowUtility.getStoredProcessException(FlowUtility.java:906)

PS : The permission access to the directory are 755, and the directory is a mount between two servers

Can someone help me please

Re: Can't export SAS Customer Intelligence

jpsm70 — Thu, 29 Mar 2018 19:39:39 GMT

Hi,

Export files are created by the sas general servers user-id (sassrv). I suggest you change the directory structure to 775 and make sure sassrv can write to it either by making sure sassrv and usera have the same primary or using a group setuid setting.

-Juan P.

Re: Can't export SAS Customer Intelligence

pcapazzi — Mon, 02 Apr 2018 14:16:20 GMT

If from the command line UserA is able to create and remove a file on the external system:

touch /ftpdtm/MAexport/test.txt
rm /ftpdtm/MAexport/test.txt

The following may help:

Change the permission to the folder to 666 (or 766 if UserA really need the ability to execute something in the folder). 6 is read/write and no execute. Make sure that the group setting of the folder is one that the SAS MA Service Account is a part of. When SAS exports a file it's not writing it as the user. So assuming that UserA and the SAS MA Service Account are both part of the SAS group change the group of the folder to SAS if it's isn't already done.

If UserA wasn't able to create and delete a file on the external system with the touch and rm command then I would look at the details of the mount that connects the folder to another system.

On a Linux system I would execute the following:

cat /proc/mounts | grep MAexport

That should show you the user ID that the connection is based on. It should show you the user ID that the connection is based on. It will also show if the mount point is set up as read/writeable (rw). If the mount point is not set up as rw then that would need to be reconfigured and re-mounted. Whatever user ID is in place would have to be given the permissions on the external file system.

Hope that helps.