Preparing for bootcamp but issues with community version.

Preparing for bootcamp but issues with community version.

  
Hello,

I am preparing for the developer bootcamp and I am tring to do training 3.1 but I have a lot of errors.
Looks like somehting is missing but I am not able to fix it, can somebody point me in the correct direction?


Hi Sander,

RichWidgets and Users are system components, and it seems that they were not published during the Agile Platform installation.

I'm pasting below the related part of the AP installation checklist. Plase follow these steps before going back to the bootcamp preparation. Let us know if this helps.

Install System Components:
  • Log in to Service Center using your administrator credentials (http://<yourserver>/ServiceCenter)
  • Go to the solutions screen (Factory -> Solutions)
  • Click Upload and Publish a Solution and select the System_Components.osp file in the installation directory (e.g.: C:\Program Files\OutSystems\Platform Server\)
  • Click 1-Click Publish

Thanks a lot for the quick reply Paulo. I will try. 
----------------------------------------------------------

Not sure how bad below is? :-)

Service Center Version: 7.0.0.19 (build 36041: tags/v7_0_0_19 @ 2012-11-29 15:22:32)

Updating eSpace Database - [Updating the database of 'ECT_Client_Connector'.]
Internal Error - [Generic SQL Error. Cannot insert duplicate key row in object 'dbo.OSSYS_META_CYCLIC_JOB' with unique index 'OSIDX_OSSYS_META_CYCLIC_JOB_9ESPACE_ID_6SS_KEY_9IS_SHARED'.<br/>The statement has been terminated. System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.OSSYS_META_CYCLIC_JOB' with unique index 'OSIDX_OSSYS_META_CYCLIC_JOB_9ESPACE_ID_6SS_KEY_9IS_SHARED'.<br/>The statement has been terminated.<br/>   at OutSystems.HubEdition.RuntimePlatform.DBHelper.#89(DbException e, IDbTransaction trans)<br/>   at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteNonQueryDontCleanParameters(IDbCommand cmd, String description, Boolean isApplication, Boolean skipLog)<br/>   at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteNonQuery(IDbCommand cmd)<br/>   at OutSystems.HubEdition.DeploymentController.DBCompilerService.ExecuteInlineStatementWithTimeout(IDbTransaction tran, String statement, Int32 timeout)<br/>   at #4Ld.#m2.#JPd(HEMessageArrayList warnings, IDbTransaction adminTrans, Dictionary`2 schemaTransactions, String fullQuery, Int32 updateDBTimeout)\r\nSQL: <br/><br/><br/>INSERT INTO "OSSYS_META_CYCLIC_JOB"(Espace_Id, SS_Key, Name, Priority, Default_Schedule, Timeout, Effective_timeout, Is_Active, Is_Shared)<br/>VALUES (6, '7fbb6a48-38a8-8a4a-f602-2ff854e3101d', 'ECT_SynchronizationTimer', 3, '00:00 00:15 00:30 00:45 01:00 01:15 01:30 01:45 02:00 02:15 02:30 02:45 03:00 03:15 03:30 03:45 04:00 04:15 04:30 04:45 05:00 05:15 05:30 05:45 06:00 06:15 06:30 06:45 07:00 07:15 07:30 07:45 08:00 08:15 08:30 08:45 09:00 09:15 09:30 09:45 10:00 10:15 10:30 10:45 11:00 11:15 11:30 11:45 12:00 12:15 12:30 12:45 13:00 13:15 13:30 13:45 14:00 14:15 14:30 14:45 15:00 15:15 15:30 15:45 16:00 16:15 16:30 16:45 17:00 17:15 17:30 17:45 18:00 18:15 18:30 18:45 19:00 19:15 19:30 19:45 20:00 20:15 20:30 20:45 21:00 21:15 21:30 21:45 22:00 22:15 22:30 22:45 23:00 23:15 23:30 23:45',20, 0, 1, 1);<br/><br/>.]
Updating eSpace Database - [Updating the database of 'ECT_Provider'.]
Internal Error - [Generic SQL Error. Cannot insert duplicate key row in object 'dbo.OSSYS_META_CYCLIC_JOB' with unique index 'OSIDX_OSSYS_META_CYCLIC_JOB_9ESPACE_ID_6SS_KEY_9IS_SHARED'.<br/>The statement has been terminated. System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.OSSYS_META_CYCLIC_JOB' with unique index 'OSIDX_OSSYS_META_CYCLIC_JOB_9ESPACE_ID_6SS_KEY_9IS_SHARED'.<br/>The statement has been terminated.<br/>   at OutSystems.HubEdition.RuntimePlatform.DBHelper.#89(DbException e, IDbTransaction trans)<br/>   at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteNonQueryDontCleanParameters(IDbCommand cmd, String description, Boolean isApplication, Boolean skipLog)<br/>   at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteNonQuery(IDbCommand cmd)<br/>   at OutSystems.HubEdition.DeploymentController.DBCompilerService.ExecuteInlineStatementWithTimeout(IDbTransaction tran, String statement, Int32 timeout)<br/>   at #4Ld.#m2.#JPd(HEMessageArrayList warnings, IDbTransaction adminTrans, Dictionary`2 schemaTransactions, String fullQuery, Int32 updateDBTimeout)\r\nSQL: <br/><br/><br/><br/>INSERT INTO "OSSYS_META_CYCLIC_JOB"(Espace_Id, SS_Key, Name, Priority, Default_Schedule, Timeout, Effective_timeout, Is_Active, Is_Shared)<br/>VALUES (7, '051149b5-b451-4e94-abbb-58bb3835440d', 'BootstrapRunner', 3, 'WhenPublished',20, 0, 1, 1);<br/><br/>.]
Updating eSpace Database - [Updating the database of 'EPA_Taskbox'.]
Updating eSpace Database - [Updating the database of 'RichWidgets'.]
Publishing Error - [Unable to upgrade database schema. Error trying to create foreign key on database field 'OSUSR_5z9_RecentItem.ESPACEID'.\r\nException: There is already an object named 'OSFRK_OSUSR_5z9_RecentItem_OSSYS_ESPACE_ESPACEID' in the database.<br/>Could not create constraint. See previous errors.\r\nSQL: ALTER TABLE "OUTSYSTEMS_"."DBO"."OSUSR_5Z9_RECENTITEM" ADD CONSTRAINT OSFRK_OSUSR_5z9_RecentItem_OSSYS_ESPACE_ESPACEID<br/>FOREIGN KEY ("ESPACEID") REFERENCES "OUTSYSTEMS_"."DBO"."OSSYS_ESPACE" ("ID") ON DELETE CASCADE;<br/>.]
Done - [15 components were successfully published. 4 components were not published: 'ECT_Client_Connector, ECT_Provider, RichWidgets, Users'.]
 
After installing the solution package again the errors are solved now. Again thanks.