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:

  1. After running the application (both from FormSpider and from direct link) FS showed message: "ORA-06512: на "FORMSPIDER.BDF_ELEMENTEVENT_QRY", line 61 ORA-06512: на "FORMSPIDER.BDF_ENGINE", line 272 ORA-06512: на "FORMSPIDER.BDF_ENGINE", line 241 ORA-06512: на "FORMSPIDER.BDF_ENGINE", line 1769 ORA-06512: на "FORMSPIDER.BDF_ENGINE", line 2147"
  2. While trying to delete application from production server in FS, it showed empty error message and did not delete the application.

What should I do to solve the problems?

asked 27 Nov, 03:55

Andrey's gravatar image

Andrey
133
accept rate: 0%

edited 27 Nov, 03:56


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,
Yalim

link

answered 28 Nov, 09:41

Yalim's gravatar image

Yalim ♦♦
2.8k5
accept rate: 20%

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>
2 581864 POpBWRUJsiOgBRehqSbq_14-11-2017_16-08-08 PostOpen 581261 581852 <clob>
3 583078 nYxxtEoyXGsQxaPfKqXA_27-11-2017_11-03-19 PostOpen 581261 581852 <clob>

When I try to edit application's events by pressing "Edit Current Application" button, I get empty error message.

link

answered 29 Nov, 07:39

Andrey's gravatar image

Andrey
133
accept rate: 0%

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
2 581864 POpBWRUJsiOgBRehqSbq_14-11-2017_16-08-08 PostOpen 581261 581852
3 583078 nYxxtEoyXGsQxaPfKqXA_27-11-2017_11-03-19 PostOpen 581261 581852

link

answered 29 Nov, 07:42

Andrey's gravatar image

Andrey
133
accept rate: 0%

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

link

answered 01 Dec, 02:59

AlfAbetas's gravatar image

AlfAbetas
611418
accept rate: 9%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×3

Asked: 27 Nov, 03:55

Seen: 65 times

Last updated: 01 Dec, 02:59


© Copyright Gerger 2017