Hello,

I am trying to schedule a simple car file report to MS Sharepoint. However I get FOC350 error. The error says ERROR WRITING OUTPUT FILE:

I am able to schedule it to a Windows based server perfectly. The issue arises when the scheduling is changed to MS Sharepoint.

-SET &RPT_NAME_FLD='Car_Test_Run';

-SET &TEMP_CTRY = IF &CTRY = 'ENGLAND' OR 'ITALY' OR 'FRANCE' THEN 'Europe' 
-            ELSE IF &CTRY = 'JAPAN' THEN 'Asia'
-            ELSE 'America';

-SET &NAME_OF_FILE = &RPT_NAME_FLD ;
-SET &FILEPATH = IF &TEMP_CTRY EQ 'Europe' THEN 'https://mysite.sp.xyz.com/personal/sumant/GS' | &NAME_OF_FILE |'.xls'
-           ELSE IF &TEMP_CTRY EQ 'Asia' THEN 'https://mysite.sp.xyz.com/personal/sumant/GS' | &NAME_OF_FILE |'.xls'
-			ELSE IF &TEMP_CTRY EQ 'America' THEN 'https://mysite.sp.xyz.com/personal/sumant/GS' | &NAME_OF_FILE |'.xls';

FILEDEF &NAME_OF_FILE DISK &FILEPATH
-RUN

TABLE FILE CAR
PRINT 
     CAR.ORIGIN.COUNTRY
     CAR.CARREC.MODEL
     CAR.BODY.BODYTYPE
     CAR.BODY.SEATS
     CAR.BODY.DEALER_COST
     CAR.BODY.RETAIL_COST
     CAR.BODY.SALES
BY CAR.COMP.CAR
WHERE CAR.ORIGIN.COUNTRY EQ '&CTRY';
ON TABLE NOTOTAL
ON TABLE HOLD AS &NAME_OF_FILE FORMAT &WFFMT
END  

The same ID is being used to schedule in both the cases. I am unable to understand why it works for one and fials for other.

Any suggestions will be helpful.
Thanks for reading.

Sumant

This message has been edited. Last edited by: Kerry,

Hi Sumant,

From our technicals: This doesn’t sound like a WebFOCUS problem, but more like a permissions issue. Please open a case with Customer Support Services, we will need to gather some more details from you, and will need a streaming session with you as well. To open a case, please call 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry

Hi Kerry,

Thanks for the response. I have sent all the details to my Web FOCUS Infra Structure team and they have conacted a SharePoint Team.
Waiting for their reply. Will definitely open a ticket with IBI, if I dont hear back from the SharePoint team.

Thanks,
Sumant