Error CommitStaticData

FlorianFlorian Posts: 1 New member
edited June 25, 2018 1:38PM in Source Control for Oracle
We started evaluating RedGate's Source Control for Oracle 4.
First results:
  • We started to connect with our git server (running TFS2018) which didn't work.
        -> We are using just a working folder now. (we need git with credential manager / ntlm)
  • We have successfully saved the database schema and objects. 
  • Now we are trying to version some static data into source control. But it actually does not work:

We have created a new table for testing purposes:
SQL for this is:
<br><div><div>CREATE TABLE testredgade (</div><div>&nbsp; id&nbsp; &nbsp; &nbsp; &nbsp;NUMBER&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NOT NULL,</div><div>&nbsp; vorname&nbsp; VARCHAR2(100 CHAR) NULL,</div><div>&nbsp; nachname VARCHAR2(100 CHAR) NULL,</div><div>&nbsp; wert&nbsp; &nbsp; &nbsp;NUMBER&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL,</div><div>&nbsp; toll&nbsp; &nbsp; &nbsp;VARCHAR2(23 CHAR)&nbsp; NULL</div><div>)</div><div>/</div><div><br></div><div>CREATE UNIQUE INDEX redgate_indx</div><div>&nbsp; ON testredgade (</div><div>&nbsp; &nbsp; id</div><div>&nbsp; )</div><div>/</div><div><br></div><div>ALTER TABLE testredgade</div><div>&nbsp; ADD CONSTRAINT pk_testredgade PRIMARY KEY (</div><div>&nbsp; &nbsp; id</div><div>&nbsp; )</div><div>/</div><div></div></div>
Please don't worry about the redgaDe typo my colleague did. :dizzy: 

That worked fine and changes are tracked in source control.
We added some content to the table:

45 Michael Koepcke   4356 HAHAHA
 1 test1   nachname1    5       
 2 test2   nachname2   67       

We added the table to static data in SCO, refreshed, and then the following happens.

We tried this on two machines, using Win10 and 2008 R2 multiple times. But with no luck.

Any help / solution would be great.

We also had a problem on the windows 10 pc when creating a project based on an existing folder. It didn't finish loading.
At the end, so we were not able to complete the "creation process of a project" using an existing folder.

Best Answer

  • Alex BAlex B Posts: 1,070 Diamond 4
    Hi All,

    We currently have a private build (version which corrects this error, please contact support if you are having a similar issue and reference this forum post and that build version.  I'll update here when this has been released into the next full release.

    Kind regards,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.