OraFAQ Forum: Forms » Forms not showing data, unless tracing is on

Home » Developer & Programmer » Forms » Forms not showing data, unless tracing is on

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Forms not showing data, unless tracing is on [message #124191]

Thu, 16 June 2005 15:49

geekgirlaz
Messages: 4
Registered: June 2005

Junior Member

When user A looks up data in a form, they are not getting any results back.
When user B looks at the same data they do receive results back. Both are using the same forms.

When adding tracing to the sqlnet.ora file, user A then can see the results.

As soon as tracing is removed from the sqlnet.ora, they are no longer able to see the results.

Why would changing the sqlnet.ora to use tracing change the results user A sees?

This is Forms 6.0.8.15.0 --- I know...the vendor won't upgrade the app to support newer release of Forms. Smile

[Updated on: Thu, 16 June 2005 15:51]

Report message to a moderator

Re: Forms not showing data, unless tracing is on [message #124223 is a reply to message #124191]

Thu, 16 June 2005 21:52

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

When trace is on, is it still the same user in the database as when trace is off?

David

Report message to a moderator

Re: Forms not showing data, unless tracing is on [message #124331 is a reply to message #124223]

Fri, 17 June 2005 10:11

geekgirlaz
Messages: 4
Registered: June 2005

Junior Member

Yep same user.

Here is what I found yesterday. When I replace the users sqlnet.ora with a new file that only includes our names servers everything works fine. I am going to go through line by line to see if I can identify which line(s) are causing the problem. Here is the bad sqlnet.ora....do you see anything that looks like it could be the culprit? Thanks for your help! Smile

AUTOMATIC_IPC = ON
#TRACE_LEVEL_CLIENT = 10
#TRACE_DIRECTORY_CLIENT = C:\TEMP
#LOG_DIRECTORY_CLIENT = C:\TEMP
SQLNET.EXPIRE_TIME = 10
NAMES.DEFAULT_DOMAIN = world
NAME.DEFAULT_ZONE = world
SQLNET.CRYPTO_SEED = "-427521303-425336520"
NAMES.DIRECTORY_PATH = (TNSNAMES,ONAMES)
DAEMON.TRACE_LEVEL = OFF
DAEMON.TRACE_MASK = (106)
NAMES.PREFERRED_SERVERS =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcpcom.world)
(PROTOCOL = TCP)
(Host = serverB)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcpcom.world)
(PROTOCOL = TCP)
(Host = serverA)
(Port = 1521)
)
)
NAME.PREFERRED_SERVERS =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcpcom.world)
(PROTOCOL = TCP)
(Host = serverA)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcpcom.world)
(PROTOCOL = TCP)
(Host = serverB)
(Port = 1521)
)
)

Report message to a moderator

Re: Forms not showing data, unless tracing is on [message #124518 is a reply to message #124331]

Sun, 19 June 2005 19:23

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Can you supply a copy of the 'good' sqlnet.ora?

David

Report message to a moderator

Previous Topic:	Fetching values into a multi record block from another table
Next Topic:	message irritating me

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 02:09:22 CST 2025