Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
7
Erster Beitrag:
vor 8 Jahren, 5 Monaten
Letzter Beitrag:
vor 8 Jahren, 5 Monaten
Beteiligte Autoren:
Toddy Utomo, Jimbo

WD14-Unable to update HFCS Store procedures

Startbeitrag von Toddy Utomo am 04.07.2009 04:59

Hi,

I'm playing around WD14: HFCS Triggers and Store Procedure

There is a error when update the store elements:
Error updating the 'Set_WD14-SP4-TRIGGER' element on the :4900@ALL_HFCS database Error returned by server:
Duplicates found for key on file.

Unable to update HFCS Store procedures

Is there a work around with this kind of error?

Regards
Toddy

Antworten:

Hi Toddy, as I can see, there's something with your server's name.The server is always named like MyServer:4900 - here the server name is missing!! No access by WDMODFIC etc ... regards, Guenter

von Jimbo - am 04.07.2009 06:33
Hi Guenter

I already give server's name, and the connection ok
but still an error occurs:

Duplicates found for key on file.

Regards
Toddy


von Toddy Utomo - am 04.07.2009 06:54

Which key? Look at the file in HyperFileSQL Control Center! Most times there are two empty keys, which are equal and therefore duplicate!

Guenter

von Jimbo - am 04.07.2009 07:12
Duplicates Key on Stored Procedures file?
this error occur when the automatic HFCS Modification

Full error message:

Error updating the 'Set_WD14-ALL-HFCS' element on the Server-2003@ALL_HFCS database Error returned by "Server-2003" server:
Duplicates found for "dwTypeVMqwIdVM" key on "Procedures" file.


Toddy


von Toddy Utomo - am 05.07.2009 03:59
Quote
Toddy Utomo
Duplicates Key on Stored Procedures file?
this error occur when the automatic HFCS Modification

Full error message:

Error updating the 'Set_WD14-ALL-HFCS' element on the Server-2003@ALL_HFCS database Error returned by "Server-2003" server:
Duplicates found for "dwTypeVMqwIdVM" key on "Procedures" file.

Toddy


Huha!?? This smells like a HFSQL-Server error, but I cannot see a file of that name in the procedures directory: ..\BDD\DatabaseName\__System\__proc ! The file there should be a single file of type .hsp - no .fic, no .ndx But, maybe, the .hsp file is a database file too? Recommended: delete the .hsp file and try again to update the procedures by use of HRefreshSet(..)
Regards, Guenter



von Jimbo - am 05.07.2009 07:15

Re: WD14-Unable to update HFCS Store procedures - workaround

Hi,

WD14 seem generate a duplicate "Set_of_Procedure" on the Project Pane - Global Procedure, after I delete this from Project Pane, and make sure the "Set_of_Procedure"
only exist on Analysis Pane, update HFCS Store procedures is OK!

Regards
Toddy





von Toddy Utomo - am 08.07.2009 05:11
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.