I have recently upgraded to 7.703 and I beleive I installed everything correctly but am not sure... When I went to run a report, it seems it was unable to create hold file. The error Message looked like the following:


Your request did not return any output to display.
Possible causes:
- No data rows matched the specified selection criteria.
- Output was directed to a destination such as a file or printer.
- An error occurred during the parsing or running of the request.


CURRENTLY DEFINED & VARIABLES STARTING WITH 'STATE':
&STATE = MD
&STATECODELIS>= MD
ENGINE SQLORA SET VARCHAR OFF
ENGINE SQLORA SET DEFAULT_CONNECTION yprd
SQL SQLORA PREPARE monthdates FOR
SELECT MIN(dd.date_id) START1, MAX(dd.date_id) END1, dd.fiscal_yr, dd.fiscal_month
from bh.date_dim dd
where fiscal_month = (SELECT fiscal_month
FROM bh.date_dim WHERE date_id=to_date(sysdate - 27)) AND
fiscal_yr = (SELECT fiscal_yr
FROM bh.date_dim WHERE date_id=to_date(sysdate - 27))
GROUP BY dd.fiscal_month, dd.fiscal_yr;
END
TABLE FILE monthdates
PRINT START1 END1
ON TABLE HOLD AS HOLD4 FORMAT ALPHA
END
(FOC1354) ACCESS FILE RECORD ABSENT, WRONG OR INCOMPLETE FOR SEGMENT :
monthdates
0 ERROR AT OR NEAR LINE 32 IN PROCEDURE mi127_allstate_rep
(FOC339) DIALOGUE MANAGER -READ FAILED: CHECK FILEDEF OR ALLOCATION FOR: -READ
HOLD4,&YEAR

Did this work before? Where in the Sql Statement is it being held as monthdates?

Yea, we copyied this report down from our production server, where it worked fine and ran it in the new test server which had just been updated to 7703, I don't know where it is being held but it worked fine in production

Charles,

This is the main error message:
(FOC1354) ACCESS FILE RECORD ABSENT, WRONG OR INCOMPLETE FOR SEGMENT : monthdates

Make sure all the Master files(.mas) AND Access files(.acx) are there. The error states the .acx file is missing, wrong or incomplete...

Tom

How do I make sure those files are there? do I copy them over from production or how do I transfer them/find them?

Update:

I tried to copy and replace the .mas file and the .acx files from production to the new test server and it still filed, could it be a premission error or some thing i didn't do properly in intalling 7703?

This message has been edited. Last edited by: Charles Richards,

Charles,
There s/b an Access/Master file for date_dim somewhere in the Application path:

? PATH
-EXIT

Put that at the top and it will list the application path(s). Maybe, just remove the bh., or, you've lost access to this file?

Tom

i got this when i ran that:

Your request did not return any output to display.
Possible causes:
- No data rows matched the specified selection criteria.
- Output was directed to a destination such as a file or printer.
- An error occurred during the parsing or running of the request.


--------------------------------------------------------------------------------


BASEAPP = /home/webfocus/ibi/apps/baseapp:
APPPATH = /home/webfocus/ibi/apps/bkuntz:
/home/webfocus/ibi/srv77/wfs/edatemp/foccache/ip003186010:
/home/webfocus/ibi/apps/production:
/home/webfocus/ibi/apps/triceps:
/home/webfocus/ibi/apps/cams:
/home/webfocus/ibi/apps/hr_development:
/home/webfocus/ibi/apps/development:
/home/webfocus/ibi/apps/samples:
/home/webfocus/ibi/apps/samples/baseapp:
/home/webfocus/ibi/apps/samples/bkuntz:
/home/webfocus/ibi/apps/samples/development:
/home/webfocus/ibi/apps/samples/ibinccde:
/home/webfocus/ibi/apps/samples/ibinccen:
/home/webfocus/ibi/apps/samples/ibincces:
/home/webfocus/ibi/apps/samples/ibinccfr:
/home/webfocus/ibi/apps/samples/ibisamp:
/home/webfocus/ibi/apps/samples/jjenning:
/home/webfocus/ibi/apps/trade_show:
/home/webfocus/ibi/apps/baseapp:
/home/webfocus/ibi/apps/lmorton:
/home/webfocus/ibi/apps/ibi_development:
/home/webfocus/ibi/apps/ibisamp:



where would it be located?

do you think it has to do with a jdbc drive not being installed?

No, you have lost access to bh.date_dim. There is no data coming from there.
Try this and see if you get any records, We "never" use mixed case:

  
ENGINE SQLORA SET VARCHAR OFF
ENGINE SQLORA SET DEFAULT_CONNECTION yprd
SQL SQLORA PREPARE MONTHDATES FOR
SELECT MIN(dd.date_id) START1, MAX(dd.date_id) END1, dd.fiscal_yr, dd.fiscal_month
from bh.date_dim dd
where fiscal_month = (SELECT fiscal_month
FROM bh.date_dim WHERE date_id=to_date(sysdate - 27)) AND
fiscal_yr = (SELECT fiscal_yr
FROM bh.date_dim WHERE date_id=to_date(sysdate - 27))
GROUP BY dd.fiscal_month, dd.fiscal_yr;
END
TABLE FILE MONTHDATES
SUM
  CNT.FISCAL_YR
END
-EXIT

See if you get a count(shouldn't the order be Year, Month?)...

I didn't see that you edited a previous post about copying and pasting to a new test server. You need the ORACLE adapter on the test server pointing there(yprd), the TNSNAMES file pointing there, etc.

You need to talk with your administrator...

To find out for sure if and if so where the srver can reach the file, you could issue these commands:

WHENCE BH MASTER
WHENCE BH ACCESS

This will show you if the file(s) can be found and where they are found.
Please note, that the master and access file have to reside in the same (app) folder.

Hi

77 has a new feature which by default does not allow you to seperate the master files and acx files in different apps (folders)
if this is the case you can add in edasprof.prf:

A new setting has been added for Master and Access File locations. METALOCATION_SAME determines whether those files must be in the same directory. The syntax is:

APP SET METALOCATION_SAME {ON|OFF}
ON
Requires that Master and Access Files be in the same directory. This is the default.

OFF
Allows Master and Access Files to be in different directories.

Tom, i ran that code above and got a count and the results are below
__________________________________________
PAGE 1

FISCAL_YR
COUNT
1
__________________________________________

I believe everything is pointing to the proper place, but im not sure, How would I check to see if it is all correcting set up?


For the WHENCE BH MASTER command and the WHENCE BH ACCESS command, Do i simply put those commands at the top of the .fex file and run it, how do i use the commands to locate the files?

Lastly, edasprof.prf, Where is this file located? Is it better just to turn it off, so then it can find it where ever it may be, most of the reports though are in the procdure folder under an app and the master files are in the master folder in the same directory as the procedure folder.

I am a new webfocus admin and I am trying to learn the ins and outs of everything, Thank you so much for your help!

Yes, put the WHENCE commands at the top in a fex, followed by -EXIT and run the fex.
The result is a page with either the location of the file(s) or an error message stating that the file could not be found.
The edasprof.prf file is a file that can be accessed through the webconsole of the server, or manually by editing it from the location D:\ibi\srv77\wfs\etc (in my case). So wherever the server is installed, followed by /wfs/etc.

With code like yours, it appears you do not want to use the WebFOCUS metadata (mas and acx), but want to run the SQL directly via the Oracle data adapter.

Please try the following code in a fex:

ENGINE SQLORA SET VARCHAR OFF
ENGINE SQLORA SET DEFAULT_CONNECTION yprd
SQL SQLORA
SELECT *
FROM BH.DATE_DIM DD
WHERE ROWNUM < 6
END

SQL SQLORA does not use the WebFOCUS metadata.

This message has been edited. Last edited by: Francis Mariani,

After I showed a coworker this forum, he looked into and was able to show me what the problem was... but we don't know what is causing it or how to fix it so hopefully someone else will know,

It turns out that for some reason the dates running in the new server are getting 9 zeros added to the end of them

test (7.703)server:
201112130000000000111213000000000
prodution(6.9.1)
2011121320111213

Does anyone know why this may be occuring? does it have to do with the java version? or maybe the adapter, I do not know, Any Ideas?

all reprots that run referencing this table for the date will all not work...

thanks for all the help so far!!

Did you try my code to verify that it has nothing to do with the metadata?

Did you compare your WebFOCUS Reporting server profiles (edasprof.prf)? Sometime, certain database behaviourial settings can be set in this file which are subsequently used for every data retrieval request (eg. ENGINE SQLORA SET VARCHAR OFF). Perhaps some setting is changing the behaviour of your dates. Are both the old and new WebFOCUS environments pointing to the same database?

where is the edasprof.prf located?

Looks like you have some reading to do. How was a new environment set up without knowing where things are?

The edasprof.prf file can be viewed and edited from the WebFOCUS Reporting Server Console and you should know the URL to that.

Do you have the WebFOCUS Home URL? Usually http://server-name:[port]/ibi_apps/homepage.jsp

You can access most WebFOCUS components from the home page. In some environments, the WebFOCUS Reporting Server Console is not shown in the home page, see your WebFOCUS Admin for it.