WD14-Unable to update HFCS Store procedures

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 <:4900> server:
Duplicates found for <dwTypeVMqwIdVM> key on <Procedures> file.

Unable to update HFCS Store procedures

Is there a work around with this kind of error?

Regards
Toddy

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

Hi Guenter

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

Duplicates found for <dwTypeVMqwIdVM> key on <Procedures> file.

Regards
Toddy

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

Guenter

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

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

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