First, I made a new application in FormSpider on developer's server. Then I exported xml file from the server and imported it into production server. Also I copied all needed DB objects from developer's server to production server. And after this I faced the next problems:
What should I do to solve the problems? |
Hi Andrey, It seems like there is somethig funny with your application events. Do you mind sending your export file to us or at least the portion which has the application events? You can also query the t_bdf_eleemtevent table to find out the events that are associated with your application. The FK column is called bdf_application_oid. There is something funny going on there like... maybe same event occuring twice for the same application? Let's resolve the first error and then we'll focus on the 2nd. Kind Regards, |
Hi Yalim. How I can send export file to you? Here are results of the query: select * from formspider.t_bdf_elementevent where bdf_application_oid=581261 1 582249 fOZbSnMLOjEPIcClqZGh_14-11-2017_17-49-27 PostOpen 581261 581852 <clob> When I try to edit application's events by pressing "Edit Current Application" button, I get empty error message. |
Here are results of the query select bdf_elementevent_oid, clone_tx, type_cd, bdf_application_oid, bdf_programunit_oid, to_char(comment_cl) comment_cl from formspider.t_bdf_elementevent where bdf_application_oid=581261 1 582249 fOZbSnMLOjEPIcClqZGh_14-11-2017_17-49-27 PostOpen 581261 581852 |
I think I had such a situation for several times (FS version 1,8). I can't delete application from IDE, because i get errors. My decision: 1) Login to DB Formspider schema and delete application events (like post event,pre open and .. ) , because after import application some applicatinios events duplicated (no unique key on the application events). At this moment i can't remember tables. 2) Delete application from IDE 3) Import application |