Error while saving in the Reverse Engineering dialog

Hi,

I am trying the new version of Open Access (Telerik_OpenAccess_ORM_2009_1_311_trial) and when I press "Save Config" or "Generate & Save Config" I always get this error :


I tried to select every table, only one table and no table and I still get the same error.  I asked a colleague to try the new Open Access and he gets the error.  This is with a new solution with only one project that contains only an app.config file.

Regards,
AlexD

Hi Alex,

 We cannot reproduce this behaviour locally. This is not a known problem and hence we will need to do some analysis  to get to the cause.

Can you describe the steps to reproduce the error? Did you try saving the config with the default values?

Alternatively you could use the CLR debugger to execute Visual Studio and try and reproduce the problem? So here is what you can do -

1. Open the CLR debugger - dbgCLR.exe, and specify the Visual Studio executable as the 'Program to Debug'
2. Go to the 'Debug->Exceptions' menu item and check the 'CLR exceptions thrown' checkbox
3. In the debugging options (available via Tools->Options->Debugging) uncheck the 'Enable Just My Code' option
4. You can now start debugging and execute the steps that reproduce the error and send us the call stack if you get an exception when trying to save the settings.
   

Greetings,
the Telerik team

Hi,

This is the step I used to reproduce the error :

1)    Create a new solution with a new project (I tried with a WinForm and Class Library)
2)    Enable Telerik on the new project (with only persistent classes)
3)    Configure the connection information (in my case, to MSSQL2008)
4)    Open the reverse mapping dialog
5)    Press “Save Config”

I get the following call stack. Is this what you were looking for (I didn't see an option to create a "dump" in CLR Debugger) ?


Greetings,
AlexD

Hello Alex,

 Thanks for the call stack. Yes that was what I was looking for. After having a closer look at the stack it seems that there was a problem while generating a default method name for the stored procedures in the database.  Can you provide us with list of stored procedures in your database.
 
 As a workaround you can select the 'Stored Procedures' node and specify a unique method name for each stored procedure in the grid.

Hope this helps.

Regards,
the Telerik team

Thanks for your reply, I will try it immediately.

Here's the list of our stored procedures (this is a legacy database) :

dt_addtosourcecontrol
dt_addtosourcecontrol_u
dt_adduserobject
dt_adduserobject_vcs
dt_checkinobject
dt_checkinobject_u
dt_checkoutobject
dt_checkoutobject_u
dt_displayoaerror
dt_displayoaerror_u
dt_droppropertiesbyid
dt_dropuserobjectbyid
dt_generateansiname
dt_getobjwithprop
dt_getobjwithprop_u
dt_getpropertiesbyid
dt_getpropertiesbyid_u
dt_getpropertiesbyid_vcs
dt_getpropertiesbyid_vcs_u
dt_isundersourcecontrol
dt_isundersourcecontrol_u
dt_removefromsourcecontrol
dt_setpropertybyid
dt_setpropertybyid_u
dt_validateloginparams
dt_validateloginparams_u
dt_vcsenabled
dt_verstamp006
dt_verstamp007
dt_whocheckedout
dt_whocheckedout_u
FindLoopPosition
Get_HoraireUserList
get_InscritProgram
Get_ManifestInfo
Get_ManifestRelation
Get_message_personalisation
get_ModuleByProgram
get_Program
Get_Resources_RessCatID
Get_UserOnLine
Get_UserXml
Ins_Result
Ins_Result_Copy
Ins_Result_Item
sp_BuildCategoryMembershipTree
sp_BuildPositionTree
sp_cascadetime
sp_checkIndex
sp_class
sp_class_delete
sp_class_insert
sp_class_trad
sp_class_trad_insert
sp_class_trad_update
sp_class_update
sp_CleanTimeBeforeCloseSession
sp_Copy_Person_Activity_Skill
sp_Copy_Skill_Acquisition_Status
sp_CountPrerequisNotCompleted
sp_CountRegisterByPeriod
SP_DELETE_GROUP_QUICK_QUERY
SP_DELETE_QUICK_QUERY
sp_DepartmentSupList
sp_Ed_CreateClass
sp_Ed_CreateClassField
sp_Ed_CreateClassFieldParam
sp_ED_CreateDisplay
sp_ED_CreatePKField
sp_Ed_CreateRelation
sp_ED_CreateTranslatable
sp_Ed_ExtendedPropertyDeletion
sp_Ed_SetupTransTable
sp_Ed_SetupTransTable_TextFields
sp_Ed_TableExtendedPropDeletion
sp_event_schedule_by_event_id
sp_event_schedule_by_event_type_id
sp_event_subscription_insert
sp_event_subscription_type_end_warning
sp_event_subscription_type_inscription
sp_event_subscription_type_start_warning
sp_event_template_instructor_fixed_date
sp_event_template_user
sp_event_template_user_course_waitinglist
sp_event_Update_ExtensionValue
Sp_F_Ims_ListPull
sp_Get_ClassSize_ByPeriodID
sp_Get_ManifestName
sp_get_ManifestNoteByID
sp_get_ManifestNoteByManifestID
sp_get_ManifestNoteByUser
sp_get_ManifestNotesByManifestID
sp_Get_ModuleByAutoProgram
sp_getAlphaList
sp_GetClassRooms
sp_GetEquipement_By_Class
sp_GetGlossary_List
sp_GetHoraireType
sp_GetInscription
sp_GetInstructorInfo
sp_GetInstructorSingleInfo
sp_GetMail_Message
sp_GetManifest_ByProgramId
sp_GetManifest_WaitingList
sp_GetManifestExamXml
sp_GetManifestInfo_Schedule
sp_GetManifestInfo_Schedule_Inline
sp_GetManifestInfoById
sp_GetManifestName
sp_GetManifests
sp_GetManifests_000
sp_GetManifests_history_000
sp_GetMessageInfo
sp_GetMessagePreview
sp_GetMessages
sp_GetModuleInfo
sp_GetNb_Place
sp_getPrerequisNotCompleted
sp_GetProgManifestInfo
sp_GetProgramInfo
sp_GetProgramSchedule
sp_GetResources_Trad
sp_GetSchedule_NbrPeriodNotBegun
sp_GetScheduleName
sp_GetStatut_Horaire
sp_GetTemplateInfo
sp_getXmlHoraire
sp_Give_Skill_Access_Rights
sp_ImportParentCategory
SP_INSERT_GROUP_QUICK_QUERY
sp_insert_person
SP_INSERT_QUICK_QUERY
sp_insert_user
sp_insert_userid
sp_Item_Insert
sp_lesson_correction
sp_lesson_correction_update
sp_lesson_data
sp_lesson_result_save
sp_lesson_save
sp_lesson_session_close
sp_lesson_time_detail_insert
sp_lesson_time_detail_update
sp_lesson_time_insert
sp_lesson_time_update
sp_List_Manifest
sp_ListBox_ActivityType
sp_ListBox_Class
sp_ListBox_Code_By_Type
sp_ListBox_Country
sp_ListBox_HoraireProgram
sp_ListBox_Instructor
sp_ListBox_Manifest
sp_ListBox_ManifestNameVersion
sp_ListBox_ManifestVersion
sp_ListBox_ManifestVisible
sp_ListBox_personalisation
sp_ListBox_PlugIn
sp_ListBox_Program
sp_ListBox_RessCat
sp_ListBox_RessCatTrad
sp_ListBox_State
sp_ListBox_State_SansHTML
sp_ListBox_Template
sp_ListBox_UsersInWaitingList
sp_ListBox_UsersNotRegistered_Period
sp_ListBox_UsersNotRegistered_Schedule
sp_mail_set_sent
sp_Manifest
sp_Manifest_HoraireList
sp_ManifestClass
sp_message_batch_info
sp_message_batch_list
sp_message_complete_info
sp_message_delete
sp_message_get_previewByBatch
sp_message_getEmail
sp_message_GetPersonalisationPreview
sp_message_insert
sp_message_to_send
sp_ObjectAccess_insert
sp_OrgUnitList
sp_personalisation_insert
sp_personalisation_Trad_insert
sp_Program_CopyModule
sp_Program_CopyProgram
sp_Program_DeleteManifestFromModule
sp_Program_DeleteModule
sp_Program_DeleteProgram
sp_Program_InsertManifestToModule
sp_Program_InsertModule
sp_Program_InsertProgram
sp_Program_List
sp_Program_UpdateManifestToModule
sp_Program_UpdateModule
sp_Program_UpdateProgram
sp_resource_association
sp_resource_dependency_insert
sp_resource_id
sp_resource_insert
sp_resource_trad_insert
sp_resource_trad_update
sp_schedule
sp_schedule_copy
sp_schedule_delete
sp_schedule_insert
sp_schedule_period
sp_schedule_period_accessory_conflict
sp_schedule_period_class_conflict
sp_schedule_period_delete
sp_schedule_period_insert
sp_schedule_period_instructor_conflict
sp_schedule_period_update
sp_schedule_preview_delete
sp_schedule_session
sp_schedule_session_delete
sp_schedule_session_insert
sp_schedule_session_update
sp_schedule_set_nb_place
sp_schedule_update
sp_scheduleChilds_delete
sp_send_cdosysmail
sp_sequence
sp_SetInscriptionDates
sp_Sql_ClassEquipment
sp_Sql_CoursAssign
sp_Sql_Dataset
sp_Sql_Dataset_SAP
sp_Sql_Instructor
sp_SQL_Note
sp_Sql_WaitingList
sp_String_ManifestName
sp_String_ManifestXmlToc
sp_Template_DeleteTemplate
sp_Template_DelTemplate
sp_Template_GetItemList
sp_Template_getManifestItem
sp_Template_getManifestRelationState
sp_Template_GetTemplateInfo
sp_Template_GetTemplateItem
sp_Template_GetTemplateLang
sp_Template_InsertItem
sp_Template_InsertNewItem
sp_Template_ManifestRelatedID
sp_Template_ManifestRelatedInfo
sp_Template_RemoveManifestRelation
sp_Template_UpdateManifest
sp_Template_UpdateManifestItem
sp_Template_UpdateTemplate
SP_udf_mandatory_values_validation
SP_udf_matching_extid_validation
SP_udf_numeric_limit_validation
SP_udf_numeric_only_validation
SP_udf_schedule_mandatory_values_validation
SP_udf_schedule_numeric_limit_validation
SP_udf_schedule_numeric_only_validation
sp_update_manifest
sp_update_timespent
up_AddObjectRightsForuser
up_Fill_TMPSAS_tables
up_GetNextEdClassNumber
Up_Inscription

Hello again,

I saw that OpenAccess removes the '_' in the name of the stored procedures, I was able to find which stored procedures caused the problem with the following query :


I tried to rename one of these in OpenAccess but the reverse engineering closes by itself with no error message.  I used the CLR Debugger to catch the call stack of the action and I receive this call stack :



Regards,
AlexD

Hello Alex,

Thank you for the analysis. There is a bug in handling that particular case (while trying to generate the static method code) and we will fix that.

As a workaround you can rename the method name by selecting the parent 'Stored Procedures' node and modifying the method name in the 'Stored Procedures' grid.

Your Telerik points have been updated.

Best wishes,
the Telerik team

Is there any update/solution for this issue? I have tried checking in the 'Use Stored Procedures' box to no avail.

Thanks,
Steve

Hello Stephen,

the workaround I am using until Telerik fixes the problem is that I have to rename one stored procedure since I have two stored procedures that have the same name when you remove the "_" in their names.  I posted an SQL query that can show you which SPs have this problem (if it is the same problem you are having).

Regards,
AlexD

Thanks,
that makes more sense. I was scratching my head a little at your previous dialogue. I'll give it a shot and post my results.

Thanks again!

Hi Stephen,

 I would like to know whether you were able to save the Reverse Mapping settings using the workaround mentioned?

 The problem has  been fixed and should be available in the next patch.

Sincerely yours,
the Telerik team

No, unfortunately the problem is still there. In this particular situation I dont have much control over the structure of the database or the names of the stored procedures. Is that next patch available as an internal download? I'd really like to use ORM for this solution, so if there is anything I can do to get it to work, I would appreciate it.

Thanks,
Steve

Hi Stephen,

 The workaround I mentioned does not require you to change the name of the stored procedure but the name of the static method for the stored procedure that is calculated by OpenAccess. You can select the 'Stored Procedures' node on the left and specify the static method name for the problematic stored procedure, in the grid.

 A patch with a fix is scheduled for later this week.

Best wishes,
the Telerik team