Failed to open form template

Hi,

1) I am trying to open a electronic form in forms builder, i am getting the below error

Failed to open a form template[09xxxxxxxxxxxxxxxxx]

[DM_API_E_BADID]ERROR "Bad Id given :null

2)Second issue is whenever i am changing changes in eform....when i select "back to draft" a form instance are creating every time. please see the below attachments 1 & 2. form template error.png form instaces.png

Need your valuable suggestions....

Regards

Baskar

form_template_error.png

Find more posts tagged with

Comments

VHK

Hi Baskar,

you can verify whether there are multiple versions of the form getting created

select * from dm_xfm_form(all) where object_name='<form name>'

if you are checking out the form and checking in obviously it does create new versions of the form.

bujji

Hi VHK,

I have executed the given query for each form, it is showing 30-40 same form names and versions as current 1.0 is showing. Is any way can we open the forms which is showing the error as Failed to open a form template. And also tell me how to avoid these form instances creating everytime when we select back to drafts for changing changes in the form.where you are refering the checkout and checkin whether in formsbuilder or DA?

VHK

Hi Bhaskar,

I mean checking out and checkin the forms create different versions of the

form,

and the other thing you can check is the definition_state of the forms like

select definition_state from dm_xfm_form where object_name=' '

if the definition_state is 2 which does mean the form is "Installed".

other possible values are 0 and 1 which does mean draft and validated

states.

bujji

HI VHK,

I fired the above query it showing the result as

dm_attr_0001 definition_state

============ ================

335 0

1 2

i.e means 335 forms are in draft and 1 is in installed state. I want only one form should displayed while opening the form in forms builder. How can we achieve it?

manishanandswami

It look like your xforms instance is corrupted .. so its better please restore this with old backup ..

or if this is not an important then delete this and create a new one ..and make sure when u create an xforms

that time it will create

follwoing object

dm_xfm_instance "same object_name of your forms "

dm_xfm_schema "same object_name of your forms "

dm_xfm_form "same object_name of your forms"

dmc_xfm_layout "same object_name of your forms "

dm_xfm_resource same name of your forms but last it add en_US(your language pack)

So it look like you delete one of them object

make sure all these object is there when u create an xforms using forms builder and never delete any of them because they have relation

Thanks

Swam Manish

VHK

Hi Bhaskar,

Try deleting the local cache i.e c:/ documentum/cache and all other cache

perhaps that could work.

butchiraju

Hi,

Even though if you are facing this issue after deleting the Cache, then Can you try opening the form in forms builder in another machine?

bujji

Hi,

I tried to open the form after deleting the cache from local system, but still the same error is coming.

Even checked from other machine but form is not opening.

manishanandswami

Can you please check

when u create an xforms that time it will create

instance of follwoing objects in your forms storage location

dm_xfm_instance "same object_name of your forms "

dm_xfm_schema "same object_name of your forms "

dm_xfm_form "same object_name of your forms"

dmc_xfm_layout "same object_name of your forms "

dm_xfm_resource same name of your forms but last it add en_US(your language pack)

So it look like you delete one of them object

make sure all these object is there when u create an xforms using forms builder and never delete any of them because they have relation

bujji

sorry for delay!!

I have checked in DA for the above form, all form instance are created but still i am facing the same problem. PFB form instance.JPG