Skip to Content (Press Enter)
2018-05-16 11-16-36
João Heleno
 
MVP
1Views
4Comments
Error when publishing eSpace after changes to BPT process
Question
BPT
I made changes to an existing process and now when I try to publish I get the following error:

Internal Error
 
Generic SQL Error. Incorrect syntax near ','. System.Data.SqlClient.SqlException: Incorrect syntax near ','.
   at OutSystems.HubEdition.RuntimePlatform.DBHelper.#aab(DbException e, IDbTransaction trans)
   at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteNonQueryDontCleanParameters(IDbCommand cmd, String description, Boolean isApplication, Boolean skipLog)
   at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteNonQuery(IDbCommand cmd)
   at OutSystems.HubEdition.DeploymentController.DBCompilerService.ExecuteInlineStatementWithTimeout(IDbTransaction tran, String statement, Int32 timeout)
   at #WMd.#n2.#wQd(HEMessageArrayList warnings, IDbTransaction adminTrans, Dictionary`2 schemaTransactions, String fullQuery, Int32 updateDBTimeout)
SQL: 
INSERT INTO "OSSYS_BPM_PROCESS_UPGRADE" (Process_Id, Activity_Def_Id, Active, Past, Future, Deleted, Espace_Version_Id) VALUES (1464,4,'0',1,0,0,6382),(1464,8,'0',1,0,0,6382),(1464,11,'0',1,0,0,6382),(1464,9,'0',1,0,0,6382),(1464,12,'1',0,0,0,6382),(1464,10,'0',0,1,0,6382),(1526,4,'0',1,0,0,6382),(1526,8,'0',1,0,0,6382),(1526,11,'0',1,0,0,6382),(1526,9,'0',1,0,0,6382),(1526,12,'1',0,0,0,6382),(1526,10,'0',0,1,0,6382);
.
 
Exception Details:
[1] Internal Error: Generic SQL Error. Incorrect syntax near ','. System.Data.SqlClient.SqlException: Incorrect syntax near ','.
   at OutSystems.HubEdition.RuntimePlatform.DBHelper.#aab(DbException e, IDbTransaction trans)
   at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteNonQueryDontCleanParameters(IDbCommand cmd, String description, Boolean isApplication, Boolean skipLog)
   at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteNonQuery(IDbCommand cmd)
   at OutSystems.HubEdition.DeploymentController.DBCompilerService.ExecuteInlineStatementWithTimeout(IDbTransaction tran, String statement, Int32 timeout)
   at #WMd.#n2.#wQd(HEMessageArrayList warnings, IDbTransaction adminTrans, Dictionary`2 schemaTransactions, String fullQuery, Int32 updateDBTimeout)
SQL: 
(...)

The Platform version is 7.0.1.5.

Any thoughts on this?
0
0
19 Jun 2013
Copy Link
2024-04-05 15-02-07
João Portela
Staff
Hi João,

Are you using SQL Server 2005?


Regards,
João Portela
0
0
19 Jun 2013
Copy Link
2018-05-16 11-16-36
João Heleno
 
MVP
Good morning João,

yes I am using SQL Server 2005. The build is 9.00.5069. 

In the meantime I managed to publish my eSpace making a copy of the process, do the changes to the copy and then publish the eSpace and delete the copied process after.

I also just received feedback from Outsystems support.. let's see what they have to say. 

Thanks,
João
0
0
20 Jun 2013
Copy Link
2024-04-05 15-02-07
João Portela
Staff
Hi João,

This problem was already fixed in the 7.0.1.7 version. I suggest you to upgrade your Platform Server version.


regards,
João Portela
1
0
20 Jun 2013
Copy Link
2018-05-16 11-16-36
João Heleno
 
MVP
Thank you João.

We'll do that.


0
0
20 Jun 2013
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.