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%20Barth's gravatar image

Volker Barth
40.0k361549819
accept rate: 34%

edited 15 Jul '10, 07:17


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%20Khamis's gravatar image

Karim Khamis
5.7k53870
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
Your answer
toggle preview

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

Question tags:

×438
×94
×24
×23
×11

question asked: 14 Jul '10, 15:09

question was seen: 7,928 times

last updated: 15 Jul '10, 07:17