Hello. I seem to be experiencing some issues trying to create hold files and write them to a writable server application folder, as detailed in The instructions here. I seem to be able to at rare times, succesfully create a hold file, but not consistently, and am running into issues trying to replace them with updates.

I don't actually get any errors when creating an initial hold file in Infoassist -- everything seems to run fine, until I need to actually see that hold file to use it:

1. Many times the hold file does not show up in the data join section in InfoAssist, or in the application folder in webfocus (at least the way i view the application folder, which is by expanding our reporting server node and navigating to it).

2. Even though I cannot see this hold file, when i go to attempt to recreate it by saving as the same-named sql hold file in infoassist, I get a prompt that the file already exists, and to choose another name. This message appears while at the same time, the conflicting file name does not show up in the application folder in the file dialog box that is prompting the message. I can provide screenshots of this.

Its like there are phantom files there, or files I cannot see even though I am the one who has created them. There are times when I notice i have to restart the webfocus browser and infoassist to get stuff to show up in the server app folders, but I've waited days to see these files show up and they are not.

The instructions seem to indicate that if the hold file you are saving already exists, it will automatically be overwritten, but the opposite seems to happening for me.

Any Ideas?

I'm wondering if I'm just not using the correct method to create hold files using InfoAssist, but I'm not finding any instructions as to how to basically just encapsulate a few table joins into a single hold file, to eliminate the need for some end users to have to mess with joins. I think the first portion of the subquery hold file instructions would be how to do it, but maybe someone can point me to a better reference?

Please note we are experiencing a bug verified by support to my knowledge with this version that involves being unable to consistently upload data to server application folders without getting errors. I am wondering if it is related?

We are running Edition: WebFOCUS
Product Release: 8.0
Service Pack: 10
Build Version: branch8010
Build/GEN Number: 73
Build/GEN Date: Tue Jul 07 17:55:14 MST 2015
Application Server: Apache Tomcat/7.0.33

This message has been edited. Last edited by: <Kathryn Henning>,

Hi rgp09,

Welcome to Focal Point.

While we wait for other members to provide any comments regarding your questions. These issues / questions may be best handled with opening a case with IBI Tech Support so that you can discuss this with the support person and possibly show them what you are trying to do and what happens. There are trace files that can be captured to get an idea of what is happening in the underlying processes.

A case can be opened using the Case Management on the IBI Technical Support Center.

If there is an issue with InfoAssist HOLD files then IBI TechSupport needs to know about it.

Thank you for participating in the Focal Point Forum.

Kindest regards,
Tamra Colangelo
Focal Point Moderator
Information Builders Inc.