FDA times out before saving

Hi all,


The form design aid on one particular workstation takes ages to save an application. The jdedebug.log (partly included below) shows that some timeout or so happens at some point

...
Jul 11 14:03:44 ** 1476/1252 Entering JDB_FreeUser
Jul 11 14:05:29 ** 1476/1252 Starting ERCommit
...

jde.log does not show anything. A full reinstall does not help and a month ago SP21 was deployed to all the workstations, with no difference.


Any clues??

Olivier


Jul 11 14:03:44 ** 1476/1252 Entering JDB_InitUser with commit mode 0.
Jul 11 14:03:44 ** 1476/1252 Entering JDB_BeginTransaction
Jul 11 14:03:44 ** 1476/1252 Entering JDB_OpenTable( Table = F98950)
Jul 11 14:03:44 ** 1476/1252 Database driver name is 'JDBODBC.DLL'
Jul 11 14:03:44 ** 1476/1252 ODBC version which the Driver Manager conforms : 03.52.0000
ODBC version which the driver supports : 03.51
The DBMS product accessed by the driver : - Microsoft SQL Server
Jul 11 14:03:44 ** 1476/1252 ODBC:S DBInitConnection envr=044A1250 conn=044A5C90 cur=3 sep=. act=1 DENVOW01 A (ONEWORLD@Central Objects - DV7333)
Jul 11 14:03:44 ** 1476/1252 Entering JDB_SelectKeyed
Jul 11 14:03:44 ** 1476/1252 ODBC:S DBInitRequest(new) conn=044A5C90 hd=042CB4D8 dr=041D5610 DENVOW01 A (ONEWORLD@Central Objects - DV7333)
Jul 11 14:03:44 ** 1476/1252 SELECT * FROM DV7333.F98950 WHERE ( UOUSER = 'DPOLIVIER' AND UOOBNM = 'P55X0001' ) ORDER BY UOUSER ASC,UOOBNM ASC,UOFMNM ASC,UOCTRLID ASC
Jul 11 14:03:44 ** 1476/1252 Entering JDB_Fetch
Jul 11 14:03:44 ** 1476/1252 Entering JDB_CloseTable(Table = F98950)
Jul 11 14:03:44 ** 1476/1252 Entering JDB_ClearSequencing
Jul 11 14:03:44 ** 1476/1252 Entering JDB_ClearSelection
Jul 11 14:03:44 ** 1476/1252 Entering JDB_ClearBuffers
Jul 11 14:03:44 ** 1476/1252 Exiting JDB_ClearBuffers with success.
Jul 11 14:03:44 ** 1476/1252 Exiting JDB_CloseTable(Table = F98950) with Success
Jul 11 14:03:44 ** 1476/1252 Entering JDB_FreeUser
Jul 11 14:05:29 ** 1476/1252 Starting ERCommit
Jul 11 14:05:29 ** 1476/1252 Starting EREndCommit
Jul 11 14:05:30 ** 1476/1252 Entering JDB_OpenTable( Table = F98EVHDR)
Jul 11 14:05:30 ** 1476/1252 Entering JDB_OpenTable( Table = F9860)
Jul 11 14:05:30 ** 1476/1252 Entering JDB_OpenTable( Table = F9862)
Jul 11 14:05:30 ** 1476/1252 Entering JDB_OpenTable( Table = F98VAR)
Jul 11 14:05:30 ** 1476/1252 Entering JDB_InitUser with commit mode 0.
Jul 11 14:05:30 ** 1476/1252 Entering JDB_BeginTransaction
Jul 11 14:05:30 ** 1476/1252 Entering JDB_FreeUser
Jul 11 14:05:30 ** 1476/1252 Starting CER_MAIN for P55X0001
Jul 11 14:05:30 ** 1476/1252 Entering GetUserProfileCache
...

If it's just one workstation, have your network person put some kind of IP monitor to see if the workstation is communicating as it should. Lot's of times it can be as simple as a kink in the cord.

The workstation seems to have normal communication. Also large file copying or lots of small file copying from and to a shared drive on the network goes fast and without problems.

This topic was addressed many times before in this forum. Make sure to turn off the Save/Restore feature within the PC's operating system. This will solve the problem.

Indeed, I read that too on the list. Mistake on my behalf, I did not mention the OS of the workstation, being Windows 2000 SP2. It does not contain the System Restore feature of XP (as far as I know).

One other cause of this could be your anti-Virus software. Try turning that off as well.

do you have multiple developers or is this the only one using FDA? What kind of server holds your central objects? Have you done any DB performance monitoring to see if you need an index or two?