Platform
Learn
Community
Support
Partner Center
Sign up
or
Log in
logout
Account Settings
Profile
messages
Messages
logout
Logout
Platform
Home
Downloads
IPP
Licensing
Project Sizing
Learn
Training
Documentation
Evaluation Guide
What's New
Community
Home
Forums
Forge
Ideas
Members
Support
Partner Guide
Resources Library
Opportunities
Account Management
Sign up
or
Log in
Home
Forums
Forge
Ideas
Members
Dear ,
What would improve your OutSystems Community experience? Let us know by taking this 2-minute survey.
Pick up the survey
Community
›
Forums
›
Technology & Integration
Error when publishing eSpace after changes to BPT process
BPT
internalerror
incorrect
syntax
Community
›
Forums
›
Technology & Integration
Error when publishing eSpace after changes to BPT process
BPT
internalerror
incorrect
syntax
New Post
New Post
João Heleno
mvp_badge
mvp_label
Posted on 2013-06-19
João Heleno
mvp_badge
mvp_label
Rank: #115
Posted on 2013-06-19
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?
João Portela
Posted on 2013-06-19
João Portela
Rank: #16
Posted on 2013-06-19
Solution
Hi João,
Are you using SQL Server 2005?
Regards,
João Portela
Solution
João Heleno
mvp_badge
mvp_label
Posted on 2013-06-20
João Heleno
mvp_badge
mvp_label
Rank: #115
Posted on 2013-06-20
Solution
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
Solution
João Portela
Posted on 2013-06-20
João Portela
Rank: #16
Posted on 2013-06-20
Solution
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
Solution
João Heleno
mvp_badge
mvp_label
Posted on 2013-06-20
João Heleno
mvp_badge
mvp_label
Rank: #115
Posted on 2013-06-20
Solution
Thank you João.
We'll do that.
Solution
Quick Reply
attachment
Choose File
No file chosen
Submit
Login to reply
New Post
Available Forums
Technology & Integration
News and Announcements
Forge Discussions
Meta
Community Quick Guides
Usability
Installation Troubleshooting
Personal Environment Troubleshooting
Forum Notifications
Email Digest Settings
Loading...