Focal Point
I get an error message when trying to run a simple modify routine

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1071098732

July 20, 2007, 04:30 AM
Adolf Mergulhao
I get an error message when trying to run a simple modify routine
0 ERROR AT OR NEAR LINE 25 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC422) THE FOCUS FILE IS NOT ON A WRITABLE DISK. CANNOT MODIFY:
0 ERROR AT OR NEAR LINE 26 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC422) THE FOCUS FILE IS NOT ON A WRITABLE DISK. CANNOT MODIFY: NETVIEWF

I can copy the files and do updates on the disk
Any Ideas.


Webfocus 7.6.2 on Windows Enterprise 2003 Server and
Webfocus 7.6.2 on HP Unix Server
July 20, 2007, 05:52 AM
ptp
Can you please post the Master File, Access File and Modify itself.

Thanks,
Paul
July 20, 2007, 07:56 AM
Adolf Mergulhao
SET WIDTH=256
-*APP HOLD LIVEHOLD
DOS DEL C:\ibi\apps\MISP\netviewf.foc
USE
C:\ibi\apps\MISP\netviewf.foc NEW
END
-RUN
CREATE FILE NETVIEWF
MODIFY FILE NETVIEWF
FREEFORM PERIOD MEASURE REPORTYPE OVERALL_RESULTS
FREEFORM TOP_12 HCIPC LE_2MB_CCTS
DATA
200612,TOTAL ORDERS COMPLETED,P06AD,.00,.00,.00,.00
200612,ORDERS PASSED PSO AGAINST CCD,P06BD,.00,.00,.00,.00
200612,FAILED PSO AGAINST CCD,P06CD,.00,.00,.00,.00
200612,ORDERS PASSED PSO AGAINST CRD,P06DD,.00,.00,.00,.00
200612,FAILED PSO AGAINST CRD,P06ED,.00,.00,.00,.00
200612,TOTAL LEAD TIME,P06FD,.00,.00,.00,.00
200612,ISSUED ORDERS,P06GD,.00,.00,.00,.00
200612,PSO RAISED ON GOLDEN I,P01AD,.00,.00,.00,.00
200612,CEASE PSO RAISED ON GOLDEN I,P01BD,.00,.00,.00,.00
200612,REARRANGE PSO RAISED ON GOLDEN I ,P01CD,.00,.00,.00,.00
200612,REARRANGE ORDERS COMPLETED,P06HD,.00,.00,.00,.00
200612,CEASE ORDERS COMPLETED,P14AD,.00,.00,.00,.00
200612,NEW ORDERS IN PIPELINE,P13AD,.00,.00,.00,.00
200612,CEASE ORDERS IN PIPELINE,P13BD,.00,.00,.00,.00
200612,REARRANGE ORDERS IN PIPELINE,P13CD,.00,.00,.00,.00
200612,UK TAIL PROVISIONS COMPLETED,P01AO,.00,.00,.00,.00
200612,UK TAIL PROVISIONS COMPLETED BY CCD,P01BO,.00,.00,.00,.00
200612,WORKING CIRCUITS,R01AM,.00,.00,.00,.00
200612,TOTAL NUMBER OF FAULTS,R01BM,.00,.00,.00,.00
200612,FAULTS CLEARED WITHIN 3 HOURS,R01CM,.00,.00,.00,.00
200612,TOTAL OUT OF SERVICE DURATION,R01DM,.00,.00,.00,.00
200612,UK TAIL FAULTS,R01EM,.00,.00,.00,.00
200612,UK TAIL FAULTS CLEARED WITHIN 3 HOURS,R01FM,.00,.00,.00,.00
200612,UK TAIL OOS DUR,R01GM,.00,.00,.00,.00
200612,UK BACKHAUL FAULTS,R01HM,.00,.00,.00,.00
200612,UK BACKHAUL FAULTS CLEARED WITHIN 3 HOURS,R01IM,.00,.00,.00,.00
200612,UK BACKHAUL OOS DUR,R01JM,.00,.00,.00,.00
200612,FAILED PSO AGAINST CCD UK,P06ID,.00,.00,.00,.00
200612,FAILED PSO AGAINST CCD SLT,P06JD,.00,.00,.00,.00
200612,FAILED PSO AGAINST CCD BD,P06KD,.00,.00,.00,.00
200612,FAILED PSO AGAINST CCD OA,P06LD,.00,.00,.00,.00
200612,FAILED PSO AGAINST CCD OTHER,P06MD,.00,.00,.00,.00
200612,FAILED PSO AGAINST CRD UK,P06OD,.00,.00,.00,.00
200612,FAILED PSO AGAINST CRD SLT,P06PD,.00,.00,.00,.00
200612,FAILED PSO AGAINST CRD BD,P06QD,.00,.00,.00,.00
200612,FAILED PSO AGAINST CRD OA,P06RD,.00,.00,.00,.00
200612,FAILED PSO AGAINST CRD OTHER,P06SD,.00,.00,.00,.00
200612,TOTAL NUMBER OF FAULTS UK,R01P1,.00,.00,.00,.00
200612,TOTAL NUMBER FAULTS CLR 3 HOURS UK,R01P2,.00,.00,.00,.00
200612,OOS DURATION UK,R01P3,.00,.00,.00,.00
200612,TOTAL NUMBER OF FAULTS OVERSEAS,R01P4,.00,.00,.00,.00
200612,TOTAL NUMBER FAULTS CLR 3 HOURS OVERSEAS,R01P5,.00,.00,.00,.00
200612,OOS DURATION OVERSEAS,R01P6,.00,.00,.00,.00
200612,TOTAL NUMBER OF FAULTS RWT,R01P7,.00,.00,.00,.00
200612,TOTAL NUMBER FAULTS CLR 3 HOURS RWT,R01P8,.00,.00,.00,.00
200612,OOS DURATION RWT,R01P9,.00,.00,.00,.00
200612,TOTAL NUMBER OF FAULTS FNF,R0110,.00,.00,.00,.00
200612,TOTAL NUMBER FAULTS CLR 3 HOURS FNF,R0111,.00,.00,.00,.00
200612,OOS DURATION FNF,R0112,.00,.00,.00,.00
200612,TOTAL NUMBER OF FAULTS ALBATROSS,R0113,.00,.00,.00,.00
200612,TOTAL NUMBER FAULTS CLR 3 HOURS ALBATROSS,R0114,.00,.00,.00,.00
200612,OOS DURATION ALBATROSS,R0115,.00,.00,.00,.00
200612,TOTAL NUMBER OF FAULTS FOREIGN NETWORKS,R0116,.00,.00,.00,.00
200612,TOTAL NUMBER FAULTS CLR 3 HOURS FOREIGN NETWORKS,R0117,.00,.00,.00,.00
200612,OOS DURATION FOREIGN NETWORKS,R0118,.00,.00,.00,.00
200612,TOTAL NUMBER OF FAULTS FOREIGN NETWORK,R0119,.00,.00,.00,.00
200612,TOTAL NUMBER FAULTS CLR 3 HOURS FOREIGN NETWORK,R0120,.00,.00,.00,.00
200612,OOS DURATION FOREIGN NETWORK,R0121,.00,.00,.00,.00
200612,TOTAL NUMBER OF FAULTS FRONTIER TO FRONTIER,R0122,.00,.00,.00,.00
200612,TOTAL NBR FLTS CLR 3 HOURS FRONTIER TO FRONTIER,R0123,.00,.00,.00,.00
200612,OOS DURATION FRONTIER TO FRONTIER,R0124,.00,.00,.00,.00
200612,IPC PIPELINE BACKLOG AGAINST CRD,R0125,.00,.00,.00,.00
200612,IPC PIPELINE BACKLOG AGAINST CCD,R0126,.00,.00,.00,.00
200612,UK TAIL PROVISIONS PIPELINE,R0127,.00,.00,.00,.00
END

The Master file

FILE=NETVIEWF, SUFFIX=FOC
SEGNAME=ROOT_SEG, SEGTYPE=S3, $
FIELD=PERIOD, ALIAS=PERIOD, FORMAT=A6, INDEX=I,
TITLE='Accounting Period',
DESCRIPTION='Accounting Period',
HELPMESSAGE='Accounting Period', $
FIELD=MEASURE, ALIAS=MEASURE, FORMAT=A50, INDEX=I,
TITLE='Measure',
DESCRIPTION='Measure',
HELPMESSAGE='Measure', $
FIELD=REPORTYPE, ALIAS=REPORTYPE, FORMAT=A5, INDEX=I,
TITLE='Report Type',
DESCRIPTION='Report Type',
HELPMESSAGE='Report Type', $
FIELD=OVERALL_RESULTS, ALIAS=OVERALL_RESULTS, FORMAT=D12.2,
TITLE='Overall Results',
DESCRIPTION='Overall Results',
HELPMESSAGE='Overall Results', $
FIELD=TOP_12, ALIAS=TOP_12, FORMAT=D12.2,
TITLE='Top 12 Countries',
DESCRIPTION='Top 12 Countries',
HELPMESSAGE='Top 12 Countries', $
FIELD=HCIPC, ALIAS=HCIPC, FORMAT=D12.2,
TITLE='High Capacity IPC',
DESCRIPTION='High Capacity IPC',
HELPMESSAGE='High Capacity IPC', $
FIELD=LE_2MB_CCTS, ALIAS=LE_2MB_CCTS, FORMAT=D12.2,
TITLE='Less than or equal 2 Mb IPC',
DESCRIPTION='Less than or equal 2 Mb IPC',
HELPMESSAGE='Less than or equal 2 Mb IPC', $


Webfocus 7.6.2 on Windows Enterprise 2003 Server and
Webfocus 7.6.2 on HP Unix Server
July 20, 2007, 08:08 AM
hammo1j
If you're amper autoprompting it will strip your backslashes out of your filename directories. Can't tell if you are from code...



Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
July 20, 2007, 09:04 AM
ptp
Try issuing:

USE CLEAR *

Before your USE

P
July 23, 2007, 09:03 AM
jgelona
Check your permissions and available disk space. I see this error in 2 cases. Bad permissions and no more disk space.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.