cannot copy a form with revision/submission mechanism SQL Table

[jdahl]

Hi,

we are using LL 9.1SP3 with webforms 2.0 and cannot copy a form with revision/submission of SQL Table. The readme of Patch 10-2003 states that issues concerning this problem are resolved with the patch but we still are not able to copy a form. Does anybody have any clues to this.

 

[ggriffit]

Are you getting any error messages, anything in the Thread/Connect/Trace logs ?

 

[jdahl]

We tested it with SQL-Server and it works. With Oracle we get an error

The error displayed in the webclient is:
Error performing Copy operation.
[Error copying form data.]

We set up connect logs and found the following error (Using Oracle 8.1.7.0.0). The SQL-statement used below is set up and executed by livelink when copying a folder which contains a form with revision mechanism to table "TestPopUp"

04/15/2004 17:10:44 0000045805: KSqlOCI::CacheFind() --> 32,07A29310)
04/15/2004 17:10:44 0000045806: KSqlCursor::Open(201f,'select * from
TestPopUp where VolumeID=-2000 and DataID=615306 and
VersionNum=0') -->'SUCCESS'
04/15/2004 17:10:44 0000045807: KSqlCursor:repare() --> 'SUCCESS'
04/15/2004 17:10:44 0000045808: Oracle error (LOCAL): Wrong number of
arguments specified in Nbind. (5.vs.0)
04/15/2004 17:10:44 0000045809: KSqlCursor::BindN() --> 'Could not bind.'
04/15/2004 17:10:44 0000045810: KSqlCursor::Close() --> 'SUCCESS'
04/15/2004 17:10:44 0000045811: KSql::ExecuteN(...) --> 'Error executing an
Sql statement.',0,0 ticks

 

[NethaZile]

This is really only an interim solution as it is the long way around, but have you attempted to XML export/import the form?

 

[ggriffit]

Have you contacted OT Support about this issue ?

 

[appnair]

Well my attempts to XML Export/Import a form template did not work out.The export occurs fine and while importing everything looks fine the template object is created but there are really no fields inside it.I contacted OT support who confirmed that XML Export/Import was not available for Form Templates.So I'm really curious about NethaZile's statement about XML Export/Import.So to end a long story short what I did to create my Form Templates in my dev environment from prod is like this
Do XML Export on Prod
Do XML import on test
Grab the dat files for the form template from prod.There should be two dat files for the current version of any form template.To do this find the providerid from the providerdata table by the dverdata docid.In one of the fileds is a path indicating the dat files
I went back and replaced the dat files on my dev server with the ones from prod.
Also OT says that this is very erasily possible in 9.2 any body on 9.2 and having done this?



Freedom is not worth having if it does not include the freedom to make mistakes.
Mahatma Gandhi

appnair

 

[jdahl]

Hi,

thanks for all your help. We also thought about XML Export/Import and we are alos in contact with OT Support.

We found the problem and can work around, so for us I think it's not as urgent anymore. Anyway it might be a LL error:
A form with revision AND submission mechanism of SQL Table on an Oracle Database cannot be copied. This is as long as no submit was done on the form, independant on how many Versions exist. On Versions the column "VersionNum" is incremented beginning with 1, the column "Seq" is 0. When the form get's submitted the col "VersionNum" is 0 and "Seq" get's incremented starting with 1. If no row with VersionNum=0 exists for a specific form (with Submission SQL Table) the copy function results in an error. It works fine on SQL-Server. What brought us to this conclusion (and we verifed that) ist the section from the connect log, where the cursor returns no results:

04/15/2004 17:10:44 0000045806: KSqlCursor::Open(201f,'select * from
TestPopUp where VolumeID=-2000 and DataID=615306 and
VersionNum=0') -->'SUCCESS'
04/15/2004 17:10:44 0000045807: KSqlCursor:repare() --> 'SUCCESS'
04/15/2004 17:10:44 0000045808: Oracle error (LOCAL): Wrong number of
arguments specified in Nbind. (5.vs.0)

Thanks,

Jens

 

[ggriffit]

I am informed from a source in OT that this is a known bug as is fixed in the latest release of WF and Forms - codenamed Nebraska - which was released a few weeks ago.