Error: FOC339 Dialogue Manager _READ FAILED

-READ is Dialog manager, while TABLE is a FOCUS command.
That means that the TABLE will be executed AFTER the evaluation of the DM commands, unless there is a -RUN in betwwen them.
So, After your TABLE request, but before teh -READ, add a -RUN.

GamP

- Using AS 8.2.01 on Windows 10 - IE11.
	in Focus since 1988

Posts: 1961 | Location: Netherlands | Registered: September 25, 2007

Ignored post by GamP posted

Silver Member

posted

I'm affraid I do have a -RUN after the TABLE FILE. I was told it was good practice to ensure that things get completed in the correct order.

Do you think I will need a FILEDEF command.

DevStudio 7.6.1. SQL Server 2005

Posts: 31 | Location: Basingstoke - England | Registered: September 17, 2007

Ignored post by thefoz posted

GinnyJakes

Expert

posted

I would suggest taking the APP HOLD out of your focexec and let the hold file be written to EDATEMP. Each user will have his/her own EDATEMP directory so will not step on each other.

The trick then is to FILEDEF the hold file created in the temp directory so that you can use it in a -READ.

TABLE FILE CAR
PRINT COUNTRY
ON TABLE HOLD FORMAT ALPHA
END
-RUN
-SET &TEMPPATH = TEMPPATH(120,'A120');
-TYPE &TEMPPATH
-SET &HOLDNAME= &TEMPPATH || 'hold.ftm';
APP FI HOLD DISK &HOLDNAME
-RUN
-REPEAT ENDLOOP 5 TIMES
-READ HOLD &COUNTRY.A10.
-TYPE &COUNTRY
-ENDLOOP

This is just an example that you can tailor to your needs.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

Ignored post by GinnyJakes posted

Silver Member

posted

Thanks Ginny. I shall give that a go.

So in your professional opinion is it best not to use the APP HOLD statement and let WebFOCUS deal with deleting the hold files. I just a little dubious of things happening automatically. Does it happen instantly the application has run as we could have an issue with space.

DevStudio 7.6.1. SQL Server 2005

Posts: 31 | Location: Basingstoke - England | Registered: September 17, 2007

Ignored post by thefoz posted

GinnyJakes

Expert

posted

IMHO, I wouldn't use APP HOLD unless

I needed to save a file that would be used by other procedures.
I was testing and I needed to look at the hold file and master.

If you do not have an APP HOLD, all held files regardless of format are written to an area called EDATEMP set up by your WebFOCUS admin. All held files are immediately removed after the application has disconnected.

In your case, if you used APP HOLD and two people ran at the same time, one would clobber the other's hold file. Taking out APP HOLD forces the files to go into edatemp and each person has an individual area where the files go.

There are other techniques to do this but for your stated application the one I showed you is the easiest.

Let me know how it turns out.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

Ignored post by GinnyJakes posted

Silver Member

posted

Thanks again.

The way we currently work it is that there is an amper variable containing the user id and this is incorporated into the hold file name so they dont get confused.

Does the EDATEMP work if the fron end of the website is ASP.NET?

DevStudio 7.6.1. SQL Server 2005

Posts: 31 | Location: Basingstoke - England | Registered: September 17, 2007

Ignored post by thefoz posted

GinnyJakes

Expert

posted

EDATEMP belongs to the reporting server piece, not the WebFOCUS client. It is always there regardless of what your front end is.

In this scenario, you don't have to put the userid in the hold name as it is temporary and will not be around after the application is finished running.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

Ignored post by GinnyJakes posted

Silver Member

posted

I shall bear all of that in mind. I've just started doing a final check of our apps to make sure everything is ok. If it means that I do not have to write code to delete files I'm all for it.

Thanks for your help

DevStudio 7.6.1. SQL Server 2005

Posts: 31 | Location: Basingstoke - England | Registered: September 17, 2007

Ignored post by thefoz posted

ira

Platinum Member

posted

Thefoz;
If you use APPHOLD you will have to clean up the environment when done, using Ginny's technique is perfect; no cleanup nec. on ur end. Only if you want the files around for later use or debugging purposes would I invoke APP Hold.

Ira wf 5.3.X AIX 533

aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0

Posts: 195 | Registered: October 27, 2006

Ignored post by ira posted

Silver Member

posted

Thanks Ira. I does seem to be the general consensus that it is best not to use the app hold in a live situation. I'm still quite new to the WebFOCUS package and I'm finding some things brilliant and other things frustrating. The project is nearly finished so I'll be back to VB soon.

Thanks again

DevStudio 7.6.1. SQL Server 2005

Posts: 31 | Location: Basingstoke - England | Registered: September 17, 2007

Ignored post by thefoz posted

hammo1j

Master

posted

You will need

ON TABLE HOLD AS Z_&CURUSER FORMAT ALPHA
END
-RUN
-READ Z_&CURUSER.EVAL, NOCLOSE &COLNAME.A110.

since dm commands do not carry out amper variable substitution by default unlike wf commands.

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

Posts: 888 | Location: Airstrip One | Registered: October 06, 2006

Ignored post by hammo1j posted