What could cause the error "External environment could not be started, main thread not found"?

While testing with an external DLL in an external C_ESQL32 environment on SA 12.0.0.2483 (GA), the above error (SQLCODE -675) was raised a few times - mainly when the same external function were called from different connections in parallel.

AFAIK, the error was only raised by events that called these functions (before doing backups and the like), not when calling these functions directly from a DBISQLC session.

As each event is always run on its own connection, it will always get its own external environment process. Therefore I don't know what kind of "main thread" might be missing.

Any hints are highly appreciated:)

Yes, I'm still testing the same DLL that has already triggered other questions as well...

asked 14 Jul '10, 15:09

Volker Barth
39.7k●358●546●815
accept rate: 34%

edited 15 Jul '10, 07:17

flat view

One Answer:

active answers oldest answers newest answers popular answers

The error is a bad one and currently being "fixed". The main problem is that the external environment's main connection thread did not establish a connection with the server within the 15 second timeout. The problem can arise if the server is very busy or if a large number of external environments are being started at the same time. Doing a backup could also cause the error while the backup starts up. If that is the case, try delaying the backup until the extenv call is complete.

permanent link

answered 14 Jul '10, 15:55

Karim Khamis
5.6k●5●38●70
accept rate: 40%

Thanks for the explanation - I just notice that the error happens in the following situation: The server is busy validating the database (on a single CPU system) and in the meantime an event is triggered that calls an external function. So I guess this is due to the connection not being established in the 15 seconds timeframe. - I will try to run the validation process with lower priority, if that might matter.

(14 Jul '10, 16:10) Volker Barth

You could also consider changing the event to trap the error and retry the call every few seconds until it succeeds.

(14 Jul '10, 16:51) Karim Khamis

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

sa-12 ×438
error ×93
external-environment ×24
external-call ×23
dll ×11

question asked: 14 Jul '10, 15:09

question was seen: 7,806 times

last updated: 15 Jul '10, 07:17

SAP SQL Anywhere

What could cause the error "External environment could not be started, main thread not found"?

Follow this question

Related questions