PDA

View Full Version : Webapp points to wrong data.



Tod Brannen
1-Sep-2005, 03:43 PM
Greetings,
After many hours of trying to debug my webapp, I found that the
webreport was not right becase the webapp was pointing to the wrong data. I
found this by making changes to the data that was supposedly being displayed
on the webreport and it did not change. The data being reported is from a
test workspace. It seems to be mixed up. It finds the webapp.vd7 in the
right workspace, but the data is pulled from the wrong workspace. Anyway,
how can I point this webapp to the data?
I tried deleting the data on the test workspace and the webapp won't even
run. I also tried removing the webshare off of the test database and it
won't run either. I checked all the registry settings I know of, and they
all point to the correct workspace. I could not find a .ws file in the
webapp registry settings. Remember this is WebApp 3 with VDF 7.0 it is not
set up the same as the new VDF 10 /11 webapp stuff.



Thanks,

Tod Brannen

Knut Sparhell
1-Sep-2005, 07:17 PM
Tod Brannen wrote:

> After many hours of trying to debug my webapp, I found that the
> webreport was not right becase the webapp was pointing to the wrong data. I
> found this by making changes to the data that was supposedly being displayed
> on the webreport and it did not change. The data being reported is from a
> test workspace. It seems to be mixed up. It finds the webapp.vd7 in the
> right workspace, but the data is pulled from the wrong workspace. Anyway,
> how can I point this webapp to the data?
> I tried deleting the data on the test workspace and the webapp won't even
> run. I also tried removing the webshare off of the test database and it
> won't run either. I checked all the registry settings I know of, and they
> all point to the correct workspace. I could not find a .ws file in the
> webapp registry settings. Remember this is WebApp 3 with VDF 7.0 it is not
> set up the same as the new VDF 10 /11 webapp stuff.

A standard VDF7 application, WebApp or Windows, have a workspace name
compiled in. If this is respected, then when deployed and no "key" is
given as parameter, it will look up this workspace in the registry at
this location:

HKEY_LOCAL_MACHINE\SOFTWARE\Data Access Corporation\Visual
DataFlex\7\Workspaces

If it find the workspace as a subkey there, it will look up the
filelistpath. This is a filename with path, usually filelist.cfg and
also usually, but not necessarily, the file path will be the same as the
datapath. If the filist contains some absolute paths it will open the
tables (datafiles) in these specific paths, otherwise and there ois no
path given, it wil look it up in the datapath. The datapath is usually
a single path, but may contain several semicolon separated ones. The
datapath is also part of the workspace, in registry.

There is no active workspace *file* in there VDF versions.

1. Open the Database Manager, select Filist and edit. Look for entries
with a specific path.

But a program might not respect the workspace given datapath. This path
may be set independetly at progran start or later.

2. Inspect the program code and look for CurrentDataPath setting.

Then, the opening of the tables doesn't nedd to be standard. A program
may use open as and use an individual path to each table.

3. Inspect the code and look for Open ... As

When a webapp is accessed IIS will route the request to the folder which
the actual web share points to. As it is an application and a as an asp
file is requested, IIS will run global.asa in the root of the shared
folder. In there it wil among other settings find

Application("hSessionMngr")=VDFSessionManager.Initialize("YourWebappName")
for WebApp 2.0 or
WebAppServerSession.Initialize("YourWebappName") for VDF 91. and later.
I don't remember exactly what WebApp 3.0 uses, but one of these.

Then it will look up this webapp name in *either* WebApp 2.0 or 3.0, and
execute the defined program file for this webapp.

4. Open the WebApp Administrator and inspect the properties of the
webapp. The Program Path should point to the program you expect it to run.

A WebApp 3.0 may *not* run simultaneously with WebApp 2.0 becuase they
would interfere with each other. There is a batch file in the WebApp
3.0 installation that wil let you switch from running the the 2.0
version to the 3.0 version and vice versa.

5. Inspect the Services to ensure what version is running. The WebApp
administrator will probably also tell you in case yiu open the wrong
version of it according to the actualy running version.

At last:

6. Open the WebApp Administrator and inspect the properties of the
webapp. The Program Path should end with webapp.vd7 and no trailing key
string. This is probaly not the case here, but in principle, and and
far as I know, you may force a program to look for settings under a
registry key under key "7" instead of it's workspace. I may be mistaken
here.



--
Knut Sparhell, Norway

Evertjan Dondergoor
2-Sep-2005, 02:43 AM
Tod,

In webapp 3 you can change the workspace-settings with dbBuilder. Select
'workspace' and then 'modify workspace'. Use Alt-tab if it has lost the
focus.

If that doesn't help, check Knuts post for possible causes.

Evertjan

"Tod Brannen" <tbrannen@ate.net> wrote in message
news:KamNWXzrFHA.1896@dacmail.dataaccess.com...
> Greetings,
> After many hours of trying to debug my webapp, I found that the
> webreport was not right becase the webapp was pointing to the wrong data.
> I
> found this by making changes to the data that was supposedly being
> displayed
> on the webreport and it did not change. The data being reported is from a
> test workspace. It seems to be mixed up. It finds the webapp.vd7 in the
> right workspace, but the data is pulled from the wrong workspace. Anyway,
> how can I point this webapp to the data?
> I tried deleting the data on the test workspace and the webapp won't even
> run. I also tried removing the webshare off of the test database and it
> won't run either. I checked all the registry settings I know of, and they
> all point to the correct workspace. I could not find a .ws file in the
> webapp registry settings. Remember this is WebApp 3 with VDF 7.0 it is not
> set up the same as the new VDF 10 /11 webapp stuff.
>
>
>
> Thanks,
>
> Tod Brannen
>
>

Tod Brannen
2-Sep-2005, 10:53 AM
Knut,
Thanks for the lengthy reply. I have already tried most of these ideas.
I will look at the rest and let you know.

Thanks again,

Tod Brannen

Tod Brannen
2-Sep-2005, 10:56 AM
Evertjan,
I know, but my dbbuilder will not open. All the workspace manager does
is write to the registry, so I can still modify these in the registry. The
problem is, that they are all correct and the data is still being pulled
from another workspace.

Tod Brannen

"Evertjan Dondergoor" <evertjan.dondergoor@dataaccess.nl> wrote in message
news:d8VyNI5rFHA.1880@dacmail.dataaccess.com...
> Tod,
>
> In webapp 3 you can change the workspace-settings with dbBuilder. Select
> 'workspace' and then 'modify workspace'. Use Alt-tab if it has lost the
> focus.
>
> If that doesn't help, check Knuts post for possible causes.
>
> Evertjan
>
> "Tod Brannen" <tbrannen@ate.net> wrote in message
> news:KamNWXzrFHA.1896@dacmail.dataaccess.com...
> > Greetings,
> > After many hours of trying to debug my webapp, I found that the
> > webreport was not right becase the webapp was pointing to the wrong
data.
> > I
> > found this by making changes to the data that was supposedly being
> > displayed
> > on the webreport and it did not change. The data being reported is from
a
> > test workspace. It seems to be mixed up. It finds the webapp.vd7 in the
> > right workspace, but the data is pulled from the wrong workspace.
Anyway,
> > how can I point this webapp to the data?
> > I tried deleting the data on the test workspace and the webapp won't
even
> > run. I also tried removing the webshare off of the test database and it
> > won't run either. I checked all the registry settings I know of, and
they
> > all point to the correct workspace. I could not find a .ws file in the
> > webapp registry settings. Remember this is WebApp 3 with VDF 7.0 it is
not
> > set up the same as the new VDF 10 /11 webapp stuff.
> >
> >
> >
> > Thanks,
> >
> > Tod Brannen
> >
> >
>
>

Tod Brannen
2-Sep-2005, 10:59 AM
Knut,
I guess I did it now. After a few changes, the website no longer works
at all.
Is there not just some way to hit the reset button and make it work? :-(
(insert loud scream).

Thanks

Tod Brannen

Evertjan Dondergoor
5-Sep-2005, 03:04 AM
Tod,

That makes me think the webapp is actually using that other workspace. This
is defined in the webapp.src:

Object oWorkspace is a cWebAppWorkspace
Set WorkspaceName to "MyWorkSpace"
End_Object

So either change that or change the datapath of that workspace.

Btw, that dbBuilder 'will not open' is a sign there might be more going on.

Evertjan

"Tod Brannen" <tbrannen@ate.net> wrote in message
news:BF0S%23b9rFHA.3396@dacmail.dataaccess.com...
> Evertjan,
> I know, but my dbbuilder will not open. All the workspace manager does
> is write to the registry, so I can still modify these in the registry. The
> problem is, that they are all correct and the data is still being pulled
> from another workspace.
>
> Tod Brannen
>
> "Evertjan Dondergoor" <evertjan.dondergoor@dataaccess.nl> wrote in message
> news:d8VyNI5rFHA.1880@dacmail.dataaccess.com...
>> Tod,
>>
>> In webapp 3 you can change the workspace-settings with dbBuilder. Select
>> 'workspace' and then 'modify workspace'. Use Alt-tab if it has lost the
>> focus.
>>
>> If that doesn't help, check Knuts post for possible causes.
>>
>> Evertjan
>>
>> "Tod Brannen" <tbrannen@ate.net> wrote in message
>> news:KamNWXzrFHA.1896@dacmail.dataaccess.com...
>> > Greetings,
>> > After many hours of trying to debug my webapp, I found that the
>> > webreport was not right becase the webapp was pointing to the wrong
> data.
>> > I
>> > found this by making changes to the data that was supposedly being
>> > displayed
>> > on the webreport and it did not change. The data being reported is from
> a
>> > test workspace. It seems to be mixed up. It finds the webapp.vd7 in
>> > the
>> > right workspace, but the data is pulled from the wrong workspace.
> Anyway,
>> > how can I point this webapp to the data?
>> > I tried deleting the data on the test workspace and the webapp won't
> even
>> > run. I also tried removing the webshare off of the test database and it
>> > won't run either. I checked all the registry settings I know of, and
> they
>> > all point to the correct workspace. I could not find a .ws file in the
>> > webapp registry settings. Remember this is WebApp 3 with VDF 7.0 it is
> not
>> > set up the same as the new VDF 10 /11 webapp stuff.
>> >
>> >
>> >
>> > Thanks,
>> >
>> > Tod Brannen
>> >
>> >
>>
>>
>
>

Igor van Houttum
5-Sep-2005, 04:58 AM
Todd,

What error message do you see when DBB refuses to open the defective
workspace?


Regards,
Igor van Houttum
Data Access Europe, BV

"Tod Brannen" <tbrannen@ate.net> wrote in message
news:BF0S%23b9rFHA.3396@dacmail.dataaccess.com...
> Evertjan,
> I know, but my dbbuilder will not open. All the workspace manager does
> is write to the registry, so I can still modify these in the registry. The
> problem is, that they are all correct and the data is still being pulled
> from another workspace.
>
> Tod Brannen
>
> "Evertjan Dondergoor" <evertjan.dondergoor@dataaccess.nl> wrote in message
> news:d8VyNI5rFHA.1880@dacmail.dataaccess.com...
>> Tod,
>>
>> In webapp 3 you can change the workspace-settings with dbBuilder. Select
>> 'workspace' and then 'modify workspace'. Use Alt-tab if it has lost the
>> focus.
>>
>> If that doesn't help, check Knuts post for possible causes.
>>
>> Evertjan
>>
>> "Tod Brannen" <tbrannen@ate.net> wrote in message
>> news:KamNWXzrFHA.1896@dacmail.dataaccess.com...
>> > Greetings,
>> > After many hours of trying to debug my webapp, I found that the
>> > webreport was not right becase the webapp was pointing to the wrong
> data.
>> > I
>> > found this by making changes to the data that was supposedly being
>> > displayed
>> > on the webreport and it did not change. The data being reported is from
> a
>> > test workspace. It seems to be mixed up. It finds the webapp.vd7 in
>> > the
>> > right workspace, but the data is pulled from the wrong workspace.
> Anyway,
>> > how can I point this webapp to the data?
>> > I tried deleting the data on the test workspace and the webapp won't
> even
>> > run. I also tried removing the webshare off of the test database and it
>> > won't run either. I checked all the registry settings I know of, and
> they
>> > all point to the correct workspace. I could not find a .ws file in the
>> > webapp registry settings. Remember this is WebApp 3 with VDF 7.0 it is
> not
>> > set up the same as the new VDF 10 /11 webapp stuff.
>> >
>> >
>> >
>> > Thanks,
>> >
>> > Tod Brannen
>> >
>> >
>>
>>
>
>

Tod Brannen
8-Sep-2005, 09:51 AM
Cannot find Termlist.Cfg


"Igor van Houttum" <Igor_dot_van_dot_Houttum@DataAccess_dot_Nl> wrote in
message news:kgsOoBgsFHA.960@dacmail.dataaccess.com...
> Todd,
>
> What error message do you see when DBB refuses to open the defective
> workspace?
>
>
> Regards,
> Igor van Houttum
> Data Access Europe, BV
>
> "Tod Brannen" <tbrannen@ate.net> wrote in message
> news:BF0S%23b9rFHA.3396@dacmail.dataaccess.com...
> > Evertjan,
> > I know, but my dbbuilder will not open. All the workspace manager
does
> > is write to the registry, so I can still modify these in the registry.
The
> > problem is, that they are all correct and the data is still being pulled
> > from another workspace.
> >
> > Tod Brannen
> >
> > "Evertjan Dondergoor" <evertjan.dondergoor@dataaccess.nl> wrote in
message
> > news:d8VyNI5rFHA.1880@dacmail.dataaccess.com...
> >> Tod,
> >>
> >> In webapp 3 you can change the workspace-settings with dbBuilder.
Select
> >> 'workspace' and then 'modify workspace'. Use Alt-tab if it has lost the
> >> focus.
> >>
> >> If that doesn't help, check Knuts post for possible causes.
> >>
> >> Evertjan
> >>
> >> "Tod Brannen" <tbrannen@ate.net> wrote in message
> >> news:KamNWXzrFHA.1896@dacmail.dataaccess.com...
> >> > Greetings,
> >> > After many hours of trying to debug my webapp, I found that the
> >> > webreport was not right becase the webapp was pointing to the wrong
> > data.
> >> > I
> >> > found this by making changes to the data that was supposedly being
> >> > displayed
> >> > on the webreport and it did not change. The data being reported is
from
> > a
> >> > test workspace. It seems to be mixed up. It finds the webapp.vd7 in
> >> > the
> >> > right workspace, but the data is pulled from the wrong workspace.
> > Anyway,
> >> > how can I point this webapp to the data?
> >> > I tried deleting the data on the test workspace and the webapp won't
> > even
> >> > run. I also tried removing the webshare off of the test database and
it
> >> > won't run either. I checked all the registry settings I know of, and
> > they
> >> > all point to the correct workspace. I could not find a .ws file in
the
> >> > webapp registry settings. Remember this is WebApp 3 with VDF 7.0 it
is
> > not
> >> > set up the same as the new VDF 10 /11 webapp stuff.
> >> >
> >> >
> >> >
> >> > Thanks,
> >> >
> >> > Tod Brannen
> >> >
> >> >
> >>
> >>
> >
> >
>
>