Error CommitStaticData
Florian
Posts: 1 New member
Hi!
We started evaluating RedGate's Source Control for Oracle 4.
First results:
We have created a new table for testing purposes:
SQL for this is:
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.
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> id NUMBER NOT NULL,</div><div> vorname VARCHAR2(100 CHAR) NULL,</div><div> nachname VARCHAR2(100 CHAR) NULL,</div><div> wert NUMBER NULL,</div><div> toll VARCHAR2(23 CHAR) NULL</div><div>)</div><div>/</div><div><br></div><div>CREATE UNIQUE INDEX redgate_indx</div><div> ON testredgade (</div><div> id</div><div> )</div><div>/</div><div><br></div><div>ALTER TABLE testredgade</div><div> ADD CONSTRAINT pk_testredgade PRIMARY KEY (</div><div> id</div><div> )</div><div>/</div><div></div></div>
Please don't worry about the redgaDe typo my colleague did. 
That worked fine and changes are tracked in source control.
We added some content to the table:
We added the table to static data in SCO, refreshed, and then the following happens.
That worked fine and changes are tracked in source control.
We added some content to the table:
CONTENT:
ID VORNAME NACHNAME WERT TOLL
45 Michael Koepcke 4356 HAHAHA
1 test1 nachname1 5
2 test2 nachname2 67
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.
Tagged:
Best Answer
-
Alex B
Posts: 1,157 Diamond 4
Hi All,
We currently have a private build (version 4.0.11.1079) 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,
Alex
Answers
Source Control for Oracle V5.0.0.1492 is now available. This new version includes the fix in private build V4.0.11.1079, to resolve this static data problem.
Please use either the Check For Updates option within the GUI (Help menu ->Check for Updates) or use this link to download.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com