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
Problems Testing Queries
Community
›
Forums
›
Technology & Integration
Problems Testing Queries
New Post
New Post
Pedro Domingues
Posted on 2010-03-12
Pedro Domingues
Rank: #119
Posted on 2010-03-12
Hi there,
I have experienced some problems when i try to test my queries. Most of times, when i try to test my queries, i receive the following error:
"The Data Model of you eSpace is inconsistent with the database.
Entity "entity" definition is not consistent with the database. Please use 1-Click Publish before testing the query."
I've already fixed all the inconsistent errors, when i publish my work i don't receive any alert of inconsistent errors and i still can't test my queries! I even compare the entities in service studio directly with the entities in database and there is no difference!
Any suggestion?
Ricardo Araújo
Posted on 2010-03-12
Ricardo Araújo
Rank: #87
Posted on 2010-03-12
Solution
Hi Pedro,
what is your Service Studio and Service Center Version?
Solution
Pedro Domingues
Posted on 2010-03-12
Pedro Domingues
Rank: #119
Posted on 2010-03-12
Solution
Hi Ricardo.
The Service Studio version is 4.2.4.60 and the Service Center version is 4.2.4.54.
Regards,
Pedro Domingues
Solution
Matthias Preuter
mvp_badge
mvp_label
Posted on 2010-03-13
Matthias Preuter
mvp_badge
mvp_label
Rank: #33
Posted on 2010-03-13
Solution
Try using the
SQL Map eSpace
this can change the entities in the Advanced query to physical table names, so you can test your query directly on the database.
This also helps when you use statements not supported in the query editor of Service Studio (like common table expressions),
Kind regards,
Matthias Preuter
Solution
Acácio Porta Nova
Posted on 2010-03-14
Acácio Porta Nova
Rank: #42
Posted on 2010-03-14
Solution
Hi Pedro
That error you are getting denotes that either you or someone working with you have made changes to entity "entity" since the last time you published the eSpace, and therefore the eSpace you are currently editing has a different definition for "entity" than the one that is currently in the server.
If you are the only person manipulating that entity, there could be a problem with the mechanism to detect changes in the entity, but other than that the message is expected. If you do get that message and, immediately after you publish the eSpace containing the definition for entity, test query still fails, then you probably have spotted a bug there.
Cheers,
Solution
Pedro Domingues
Posted on 2010-03-15
Pedro Domingues
Rank: #119
Posted on 2010-03-15
Solution
Hi there Matthias Preuter.
Thanks for your answer, i will try that.
Hi there Acácio.
I'm not the only person who's working on this project. Certainly i've spotted a bug here because i've already published several times and i still get the error message. The only way to test my queries is to put a breakpoint and run the eSpace.
Regards,
Pedro Domingues
Solution
Acácio Porta Nova
Posted on 2010-03-15
Acácio Porta Nova
Rank: #42
Posted on 2010-03-15
Solution
Hi Pedro
Can you post the eSpace and indicate what query it is where you get the problem? Or if you would like, try submitting the eSpace to support@outsystems.com so that you can get official assistance from OutSystems Support.
Cheers,
Solution
Pedro Domingues
Posted on 2010-03-15
Pedro Domingues
Rank: #119
Posted on 2010-03-15
Solution
Acácio,
Maybe i'll submit the eSpace to OutSystems support. There's a lot of queries that don't work due to inconsistency.
Thanks anyway.
Cheers
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...