PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → HF Auto Modification problem
HF Auto Modification problem
Débuté par Miguel Hilado, 22 fév. 2008 11:12 - 5 réponses
#1
Posté le 22 février 2008 - 11:12
I modified the structure of several FIC files on my development PC and was trying to update the files on the production machine when I got this error message for ONLY ONE file:

The files are involved in a transaction interrupted by computer.

Cancel this before you can perform the automatic modification.

Even when no one is accessing the database, this error message doesn't go away.

Does anyone have any suggestion on what to do? Or what could have caused this? Even WDMAP can't read the file anymore since the file structure has changed.

Thanks in advance.

- Mike
#2
Posté le 22 février 2008 - 11:56
Hi Mike...

According to the message, it seems that:

- your program is using transactions

- One of the transaction was interrupted

- This transaction was NOT cancelled (you should test for this at the start of the program and automatically cancel interrupted transactions)

- the automatic update refuse to do its job in that case (probably because in some case, canceling the transaction would become impossible)

So, you have to:

- restore you DB backup (the one you did just before the upgrade)

- cancel the transaction

- redo the upgrade

Best regards

Fabrice



>I modified the structure of several FIC files on my development PC and was trying to update the files on the production machine when I got this error message for ONLY ONE file:

The files are involved in a transaction interrupted by computer.


>Cancel this before you can perform the automatic modification.

Even when no one is accessing the database, this error message doesn't go away.


>Does anyone have any suggestion on what to do? Or what could have caused this? Even WDMAP can't read the file anymore since the file structure has changed.

Thanks in advance.


>- Mike
#3
Posté le 22 février 2008 - 11:56
Hello Mike,

I don't know if your problem is the same as mine some weeks ago, but Christoph pointed me in the right direction:

Maybe WDOptimizer.exe can help you.

Christoph

HTH,

Louis.
#4
Posté le 22 février 2008 - 12:07
Miguel Hilado ha scritto
> I modified the structure of several FIC files on my development PC
and was trying to update the files on the production machine when I got
this error message for ONLY ONE file:
> The files are involved in a transaction interrupted by computer.
> Cancel this before you can perform the automatic modification.
> Even when no one is accessing the database, this error message
doesn't go away.
> Does anyone have any suggestion on what to do? Or what could have
caused this? Even WDMAP can't read the file anymore since the file
structure has changed.
> Thanks in advance.
> - Mike

Hi Miguel,
look for WDTrans in Tools menu.
You can integrate it in your setup.
Bye


--

Andrea Chiadò Piat

BIT INFORMATICA

Via Giordano 7

10073 - Ciriè (TO)

Tel 011 9205455

Fax 011 9210394

Mob 348 6017526



Get help from Andrea Chiado Piat!
<http://www.crossloop.com/BitInformaticaAssistenza…>
#5
Posté le 22 février 2008 - 12:53
Thanks for your very quick reply, Fabrice. You're right - the program does use transactions but no one reported any problems so I wasn't aware of it. I will implement your recommendation to test for interrupted transactions and cancel them automatically.

But in the meantime I did some serious reading of the online documentation and found out that using WDOptimizer allowed me to cancel the interrupted transaction interactively. And the WDModFic.exe ran completely. So I did not have to restore any backups.

But thanks for the tips. I look forward to learning many more from your DVDs which I ordered last weekend.

- Mike

>Hi Mike...

According to the message, it seems that:


>- your program is using transactions

- One of the transaction was interrupted


>- This transaction was NOT cancelled (you should test for this at the start of the program and automatically cancel interrupted transactions)

- the automatic update refuse to do its job in that case (probably because in some case, canceling the transaction would become impossible)


>So, you have to:

- restore you DB backup (the one you did just before the upgrade)


>- cancel the transaction

- redo the upgrade


>Best regards

Fabrice
#6
Posté le 22 février 2008 - 12:53
Thanks to all who have responded so far. The support from this group is exceptional.

This incident has reinforced my belief that WinDev is a very flexible and powerful tool. But it is so deep that discovering its power takes serious research and a very helpful group.
→ Revenir à WINDEV 2024