Hi guys, we have just set up a new WebFocus 8 environment and I am trying to migrate our application(s) to our QA server to no avail. I can create export of Domain, Application, Folders and import successfully to our QA environment. So at this point I have the domain the folder inside the domain and all the .mas files that belong to the application. As soon as I Add a focexec to the export and try to import I am getting the following error. I tried it every which way, ie addnew/update. I ran a SQL Profiler Trace to monitor the SQL calls and I can see in the trace file the duplicate call to insert to the WF_NLSOBJ table which causes the primary key violation. Anybody else experience this and maybe have a solution, thanks in advance.



Item Parent Folder Does not Exist /WFC/Repository/DOMAINNAME/FOLDERNAME/Focexec.name

sqlserverexception Violation Of Primary Key Constraint
Call: INSERT INTO WF_NLSOBJ(OBJDESC, SUMMARY, WF_LNG, OBJ_HANDLE) VALUES(?,?,?,?)

I take it I cant add image or attach file so here is the jist of the error.

This message has been edited. Last edited by: <Kathryn Henning>,

HDavidson,

Are you exporting the handle with your content resources? I had a situation where I did not export the handle with one of my folders, and then whenever I went to add to that folder I couldn't do so because my QA environment had created a new handle for the resource. So when it went to insert to focexec into the folder, the folder handles didn't match and I got an error. To resolve this I deleted the folder in QA and re-did my export, making sure that I moved the folder WITH the handle. Now when I move just the focexec without the folder, I no longer run into any issues with my import/export.

Thanks for the reply Eric, yes I have tried the checking the box retain handles, and without checking the box. I miss the good old days of just copying focexec files to the server and be done with it

If you still want to do it that way, you can. Just create both environments in your Dev Studio and copy paste. Works the same as it always did. Personally I prefer the change management of today as opposed to the change management of 77, but I know of people on this forum that disagree with me. I guess its a personal preference to a certain extent.

Have you opened a case with IBI? They should be able to help you resolve your issue.

Thanks, now when you say in both environments what does that mean exactly, I just started working with app studio, our wf tool has always been notepad in the past as we did not use .mas file but rather stored procedures and dynamic grouping inside the focexec so they would never open up in app studio. In my environment tree I have content, which is where I created the domain/folder/subfolder/focexecs. Where are your referring to Local Projects ? I have had a case open with IBI since we had one fo their boys here to get us set up with 8, he recreated the issue on his machine also .

I currently stay away from App Studio in my 8008 install. Its to unstable for my liking. But if I remember correctly, you should be able to right click your environment in the environment tree and add a new environment. Put in your QA information and you'll be off rocking and rolling. Since i'm unfamiliar with App Studio, I don't know how copying and pasting between environments work. If you were to install Developer Studio its as easy as "select file, ctrtl+c, select new folder, ctrl+v"