Skip to Content (Press Enter)
OutSystems.com
Personal Edition
Community
Support
Training
Training
Online Training
Developer Schools
Boot Camps
Certifications
Tech Talks
Documentation
Documentation
Overview
ODC
O11
Forums
Forge
Get Involved
Get Involved
Jobs
Ideas
Members
Mentorship
User Groups
Platform
Platform
ODC
O11
Search in OutSystems
Log in
Get Started
Back to Forums
Darrell Harr
1
Views
14
Comments
after upgrade from platform 8 to 9 ... integration studio connection to database err
Question
in Integration studio 9 (this worked with no issue on platform 8)
right click on Enties and select (Connect to external table or View)
A list of "Available Database Connections" is shown...
When I select one of the connections I get a time out error.....
something like this displays in the window.....
"There was an error processing your request. Please try again later..."
in HTML....
Some connection strings work??
doesn't seem to matter the user access or whether the connection string was saved in Service Studio or not??
Darrell Harr
Pedro Borges
Hello Darrel,
Which
Integration Studio and Platform Server versions are you using?
Can you access the Database Connection that crashes Integration Studio thorugh Service Center?
Darrell Harr
I'm using platform 9 .... and this is where the error is....
I can access the connections in service Studio 9 and the test is successful....
Pedro Borges
Do you see any error on the Event Viewer when the Platform Server is installed?
Do you see any error on Service Center's Error Log?
Darrell Harr
I don't see any errors in Service Center ..... just a time out
Darrell Harr
Here is the error log....
Darrell Harr
here's the stack trace from the webservice abort
eSpaceVer: 0 (Id=1, PubId=1, CompiledWith=9.0.0.11)
RequestUrl: https://llc1gdvlpapp01/ServiceCenter/IntegrationStudio.asmx (Method: POST)
AppDomain: /LM/W3SVC/1/ROOT/ServiceCenter-3-130628058716192384
FilePath: C:\...\PS\running\ServiceCenter.1736518936\
Locale: en-US
DateFormat: yyyy-MM-dd
PID: 3852 ('w3wp', Started='12/10/2014 5:42:27 PM', Priv=186Mb, Virt=700Mb)
TID: 26
Thread Name:
.NET: 4.0.30319.18408
Stack:
Thread was being aborted.
at ssServiceCenter.Actions.WsIntegrationStudio.WebSrvcIntegrationStudioEntityIntrospectionGetDatabases(HeContext heContext, String inParamusername, String inParampassword, RCEntityIntrospectionServerRecord inParamserver, RLEntityIntrospectionDatabaseRecordList& outParamdatabases)
at ssServiceCenter.WebServices.IntegrationStudio.EntityIntrospectionGetDatabases(String inWSusername, String inWSpassword, WORCEntityIntrospectionServerRecord inWSserver, WORCEntityIntrospectionDatabaseRecord[]& outWSdatabases)
Darrell Harr
the error log was cut off .... trying again...
Pedro Borges
Hello,
it looks like the introspecting the databases available on some of your servers is taking too long.
The databases that you are trying to connect to are they Oracle or SQL Server databases? Do you have linked servers configured on those databases?
Darrell Harr
they are sql server... there was no issue on Platform 8 ... and our connection is fast via sqlserver....
there should be no linked servers involved
like I said some of the connection strings work OK... different servers....
Seems like the Integration platform can't connect to the database server??? even though in Service Center the "Test" button runs fast and is OK....
wonder if there is something in the configuration that can be looked at?? as when we updated to 9 we had to redo the database connection ??
Pedro Borges
How did you upgrade the Database Connections? Did you create new connections with the new format and deleted the old ones or did you upgrade them in place?
Darrell Harr
we upgraded them in place
Pedro Borges
Darrell if you have access to the DB Connection database, you could try to execute the folowing queries:
select * from master.sys.databases
then
exec sp_linkedservers // this will give you a list of linked servers
for each linked server
exec sp_catalogs '<linked server name>'
If any of those queries take more than around 90 seconds you can try to:
Increase IIS request timeout, and
Increase the DBIntrospectionTimeout parameter on server.hsconf and then apply the settings with Configuration Tool
If the problem persists, please contact our support. We might have to dig deeper to help you.
Venkatesh Gude
I hope you are directly trying to import entity without creating it in integration studio. Try create entity with same fields as per the existing database then click on import entity this should work..
Regards,
venkat gude.
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting.
See the full guidelines
 Loading...