PDA

View Full Version : PSQL CK3.0.0.11 - ERROR 24006 ??



Giuseppe
19-Nov-2005, 08:29 PM
To DAC,
I am trying DATABASE_MODE = 1
After the uprade of the my applications with the new method I have some
errors.
An error is 24006 which i not finded on documentation.
For Your tests you may try the attached example test2.vw.
In the test2.vw I open some TABLE of some DATABASE.
Create 2 DATABASE and some TABLE (see the comments in then view)
Compile the view and run it.
Click more time on the button, It show error 24006

Regards
Giiseppe Catania
EasyAccess s.a.s.

Martin Moleman
21-Nov-2005, 03:22 AM
Giuseppe,

Subtract 21000 from the error number and lookup the error code in the
Pervasive help. So in this case lookup error 3006.
Also check the pvsw.log for possible additional information.

Regards,

Martin Moleman
Data Access Europe



"Giuseppe" <info@easyaccess.it> wrote in message
news:PE2IXHX7FHA.3660@dacmail.dataaccess.com...
> To DAC,
> I am trying DATABASE_MODE = 1
> After the uprade of the my applications with the new method I have some
> errors.
> An error is 24006 which i not finded on documentation.
> For Your tests you may try the attached example test2.vw.
> In the test2.vw I open some TABLE of some DATABASE.
> Create 2 DATABASE and some TABLE (see the comments in then view)
> Compile the view and run it.
> Click more time on the button, It show error 24006
>
> Regards
> Giiseppe Catania
> EasyAccess s.a.s.
>
>
>
>
>
>

Giuseppe
22-Nov-2005, 01:37 PM
Martin,
I have looked Pervasive Help and have reported theerror 3006 under here.
3006: The MicroKernel router detected an invalid session
The session information contained in a position block is invalid.
This status code occurs for one of the following reasons:
The application is trying to use a position block for a file that
resides on an engine and for which the connection has been
previously terminated via a B_STOP (25) or B_RESET (28) operation.
The application is trying to use a position block for a file that
resides on a remote server and that encountered an abnormal
network error on a previous operation.
When using only the NetBIOS protocol with a remote Workgroup engine, the
client is sending more bytes than can fit into
the engine's network read buffer. Go the machine where the remote
Workgroup engine is installed, and try increasing the
value of the configuration parameter, Server > Communication > Buffer
Size > Read Buffer Size.

I have changed to max value of Read Buffer Size to 65536 bat bat nothing is
changed.
Please can you try this example?
Procedure OnClick
Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=DITTE" as 201
Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=UTENTI" as 202
Open "DFBTRDRV:btrv://localhost/DITTA001PSQL?table=ANAMAG" as 203
CLOSE 201
CLOSE 202
CLOSE 203
Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=DITTE" as 201
Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=UTENTI" as 202
Open "DFBTRDRV:btrv://localhost/DITTA001PSQL?table=ANAMAG" as 203
CLOSE 201
CLOSE 202
CLOSE 203
End_Procedure // OnClick
With this procedure I have the same error with message CLOSING FILE.DDF
I have attached the log file pvsw.log
What I can do?
Regards
Giuseppe Catania



"Martin Moleman" <martin.moleman@dataaccess.nl> ha scritto nel messaggio
news:xGpSkSn7FHA.3872@dacmail.dataaccess.com...
> Giuseppe,
>
> Subtract 21000 from the error number and lookup the error code in the
> Pervasive help. So in this case lookup error 3006.
> Also check the pvsw.log for possible additional information.
>
> Regards,
>
> Martin Moleman
> Data Access Europe
>
>
>
> "Giuseppe" <info@easyaccess.it> wrote in message
> news:PE2IXHX7FHA.3660@dacmail.dataaccess.com...
>> To DAC,
>> I am trying DATABASE_MODE = 1
>> After the uprade of the my applications with the new method I have some
>> errors.
>> An error is 24006 which i not finded on documentation.
>> For Your tests you may try the attached example test2.vw.
>> In the test2.vw I open some TABLE of some DATABASE.
>> Create 2 DATABASE and some TABLE (see the comments in then view)
>> Compile the view and run it.
>> Click more time on the button, It show error 24006
>>
>> Regards
>> Giiseppe Catania
>> EasyAccess s.a.s.
>>
>>
>>
>>
>>
>>
>
>
>

Martin Moleman
24-Nov-2005, 09:28 AM
Hello Giuseppe,

I tried to reproduce this, but was unable to do so.

I few questions/suggestions:

Can you try to determine on exactly which Open or Close the error occurs.
Can you try the same with a 'normal' open, instead of the "Open As" you are
using now.
With the Pervasive Monitor you can see which tables are opened. If you run
your program step by step you may be able to see if a table is closed in the
monitor, while it is still open in the program.
How is the AUTO_LOGOUT in DFBTRDRV.INT set ? Can you try if there is a
difference if you turn it on or off ?

Regards,

Martin Moleman
Data Access Europe





"Giuseppe" <info@easyaccess.it> wrote in message
news:FkVVaP57FHA.4000@dacmail.dataaccess.com...
> Martin,
> I have looked Pervasive Help and have reported theerror 3006 under here.
> 3006: The MicroKernel router detected an invalid session
> The session information contained in a position block is invalid.
> This status code occurs for one of the following reasons:
> The application is trying to use a position block for a file that
> resides on an engine and for which the connection has been
> previously terminated via a B_STOP (25) or B_RESET (28) operation.
> The application is trying to use a position block for a file that
> resides on a remote server and that encountered an abnormal
> network error on a previous operation.
> When using only the NetBIOS protocol with a remote Workgroup engine,
> the client is sending more bytes than can fit into
> the engine's network read buffer. Go the machine where the remote
> Workgroup engine is installed, and try increasing the
> value of the configuration parameter, Server > Communication > Buffer
> Size > Read Buffer Size.
>
> I have changed to max value of Read Buffer Size to 65536 bat bat nothing
> is changed.
> Please can you try this example?
> Procedure OnClick
> Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=DITTE" as 201
> Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=UTENTI" as 202
> Open "DFBTRDRV:btrv://localhost/DITTA001PSQL?table=ANAMAG" as 203
> CLOSE 201
> CLOSE 202
> CLOSE 203
> Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=DITTE" as 201
> Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=UTENTI" as 202
> Open "DFBTRDRV:btrv://localhost/DITTA001PSQL?table=ANAMAG" as 203
> CLOSE 201
> CLOSE 202
> CLOSE 203
> End_Procedure // OnClick
> With this procedure I have the same error with message CLOSING FILE.DDF
> I have attached the log file pvsw.log
> What I can do?
> Regards
> Giuseppe Catania
>
>
>
> "Martin Moleman" <martin.moleman@dataaccess.nl> ha scritto nel messaggio
> news:xGpSkSn7FHA.3872@dacmail.dataaccess.com...
>> Giuseppe,
>>
>> Subtract 21000 from the error number and lookup the error code in the
>> Pervasive help. So in this case lookup error 3006.
>> Also check the pvsw.log for possible additional information.
>>
>> Regards,
>>
>> Martin Moleman
>> Data Access Europe
>>
>>
>>
>> "Giuseppe" <info@easyaccess.it> wrote in message
>> news:PE2IXHX7FHA.3660@dacmail.dataaccess.com...
>>> To DAC,
>>> I am trying DATABASE_MODE = 1
>>> After the uprade of the my applications with the new method I have some
>>> errors.
>>> An error is 24006 which i not finded on documentation.
>>> For Your tests you may try the attached example test2.vw.
>>> In the test2.vw I open some TABLE of some DATABASE.
>>> Create 2 DATABASE and some TABLE (see the comments in then view)
>>> Compile the view and run it.
>>> Click more time on the button, It show error 24006
>>>
>>> Regards
>>> Giiseppe Catania
>>> EasyAccess s.a.s.
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>
>
>

Giuseppe
24-Nov-2005, 10:35 AM
Hello Martin,
Now I have set the AUTO_LOGOUT in DFBTRDRV.INT to 0 (the default is 1)
I have tried and so not there is more the error.
For general Is it correct this set?

P.S.
With AUTO_LOGOUT to 0 the Pervasive Monitor after that I click to button
show always the MicroKernel Active Files
after the exit_application the Monitor show blank Active Files.
With AUTO_LOGOUT to 1 the Pervasive Monitor after that I click to button
not show the MicroKernel Active Files
The problems is only when I have DATABASE not equal

Procedure OnClick
Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=DITTE" as 201
Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=UTENTI" as 202

Open "DFBTRDRV:btrv://localhost/DITTA001PSQL?table=ANAMAG" as 203
<---------------- The DATABASE is not equal to up

CLOSE 201
CLOSE 202
CLOSE 203
Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=DITTE" as 201
Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=UTENTI" as 202

Open "DFBTRDRV:btrv://localhost/DITTA001PSQL?table=ANAMAG" as 203
<---------------- The DATABASE is not equal to up

CLOSE 201
CLOSE 202
CLOSE 203

End_Procedure // OnClick


Regards
Giuseppe Catania



"Martin Moleman" <martin.moleman@dataaccess.nl> ha scritto nel messaggio
news:GtGpUNQ8FHA.3872@dacmail.dataaccess.com...
> Hello Giuseppe,
>
> I tried to reproduce this, but was unable to do so.
>
> I few questions/suggestions:
>
> Can you try to determine on exactly which Open or Close the error occurs.
> Can you try the same with a 'normal' open, instead of the "Open As" you
> are using now.
> With the Pervasive Monitor you can see which tables are opened. If you run
> your program step by step you may be able to see if a table is closed in
> the monitor, while it is still open in the program.
> How is the AUTO_LOGOUT in DFBTRDRV.INT set ? Can you try if there is a
> difference if you turn it on or off ?
>
> Regards,
>
> Martin Moleman
> Data Access Europe
>
>
>
>
>
> "Giuseppe" <info@easyaccess.it> wrote in message
> news:FkVVaP57FHA.4000@dacmail.dataaccess.com...
>> Martin,
>> I have looked Pervasive Help and have reported theerror 3006 under here.
>> 3006: The MicroKernel router detected an invalid session
>> The session information contained in a position block is invalid.
>> This status code occurs for one of the following reasons:
>> The application is trying to use a position block for a file that
>> resides on an engine and for which the connection has been
>> previously terminated via a B_STOP (25) or B_RESET (28) operation.
>> The application is trying to use a position block for a file that
>> resides on a remote server and that encountered an abnormal
>> network error on a previous operation.
>> When using only the NetBIOS protocol with a remote Workgroup engine,
>> the client is sending more bytes than can fit into
>> the engine's network read buffer. Go the machine where the remote
>> Workgroup engine is installed, and try increasing the
>> value of the configuration parameter, Server > Communication > Buffer
>> Size > Read Buffer Size.
>>
>> I have changed to max value of Read Buffer Size to 65536 bat bat nothing
>> is changed.
>> Please can you try this example?
>> Procedure OnClick
>> Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=DITTE" as 201
>> Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=UTENTI" as 202
>> Open "DFBTRDRV:btrv://localhost/DITTA001PSQL?table=ANAMAG" as 203
>> CLOSE 201
>> CLOSE 202
>> CLOSE 203
>> Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=DITTE" as 201
>> Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=UTENTI" as 202
>> Open "DFBTRDRV:btrv://localhost/DITTA001PSQL?table=ANAMAG" as 203
>> CLOSE 201
>> CLOSE 202
>> CLOSE 203
>> End_Procedure // OnClick
>> With this procedure I have the same error with message CLOSING FILE.DDF
>> I have attached the log file pvsw.log
>> What I can do?
>> Regards
>> Giuseppe Catania
>>
>>
>>
>> "Martin Moleman" <martin.moleman@dataaccess.nl> ha scritto nel messaggio
>> news:xGpSkSn7FHA.3872@dacmail.dataaccess.com...
>>> Giuseppe,
>>>
>>> Subtract 21000 from the error number and lookup the error code in the
>>> Pervasive help. So in this case lookup error 3006.
>>> Also check the pvsw.log for possible additional information.
>>>
>>> Regards,
>>>
>>> Martin Moleman
>>> Data Access Europe
>>>
>>>
>>>
>>> "Giuseppe" <info@easyaccess.it> wrote in message
>>> news:PE2IXHX7FHA.3660@dacmail.dataaccess.com...
>>>> To DAC,
>>>> I am trying DATABASE_MODE = 1
>>>> After the uprade of the my applications with the new method I have some
>>>> errors.
>>>> An error is 24006 which i not finded on documentation.
>>>> For Your tests you may try the attached example test2.vw.
>>>> In the test2.vw I open some TABLE of some DATABASE.
>>>> Create 2 DATABASE and some TABLE (see the comments in then view)
>>>> Compile the view and run it.
>>>> Click more time on the button, It show error 24006
>>>>
>>>> Regards
>>>> Giiseppe Catania
>>>> EasyAccess s.a.s.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>>
>
>

Giuseppe Catania
24-Nov-2005, 01:01 PM
Martin,
I have also tried this procedure with AUTO_LOGOUT TO 0
Procedure OnClick // ERROR 24006
Login "LOCALHOST/DATICOMPSQL" "Master" "pippo" "DFBTRDRV"
Login "LOCALHOST/DITTA001PSQL" "Master" "pippo" "DFBTRDRV"
Open "DFBTRDRV:btrv://LOCALHOST/DATICOMPSQL?table=DITTE" as 1
Open "DFBTRDRV:btrv://LOCALHOST/DATICOMPSQL?table=UTENTI" as 2
CLOSE 1
CLOSE 2
End_Procedure // OnClick
If you click more time this procedure run error

Regard
Giuseppe Catania


"Martin Moleman" <martin.moleman@dataaccess.nl> ha scritto nel messaggio
news:GtGpUNQ8FHA.3872@dacmail.dataaccess.com...
> Hello Giuseppe,
>
> I tried to reproduce this, but was unable to do so.
>
> I few questions/suggestions:
>
> Can you try to determine on exactly which Open or Close the error occurs.
> Can you try the same with a 'normal' open, instead of the "Open As" you
> are using now.
> With the Pervasive Monitor you can see which tables are opened. If you run
> your program step by step you may be able to see if a table is closed in
> the monitor, while it is still open in the program.
> How is the AUTO_LOGOUT in DFBTRDRV.INT set ? Can you try if there is a
> difference if you turn it on or off ?
>
> Regards,
>
> Martin Moleman
> Data Access Europe
>
>
>
>
>
> "Giuseppe" <info@easyaccess.it> wrote in message
> news:FkVVaP57FHA.4000@dacmail.dataaccess.com...
>> Martin,
>> I have looked Pervasive Help and have reported theerror 3006 under here.
>> 3006: The MicroKernel router detected an invalid session
>> The session information contained in a position block is invalid.
>> This status code occurs for one of the following reasons:
>> The application is trying to use a position block for a file that
>> resides on an engine and for which the connection has been
>> previously terminated via a B_STOP (25) or B_RESET (28) operation.
>> The application is trying to use a position block for a file that
>> resides on a remote server and that encountered an abnormal
>> network error on a previous operation.
>> When using only the NetBIOS protocol with a remote Workgroup engine,
>> the client is sending more bytes than can fit into
>> the engine's network read buffer. Go the machine where the remote
>> Workgroup engine is installed, and try increasing the
>> value of the configuration parameter, Server > Communication > Buffer
>> Size > Read Buffer Size.
>>
>> I have changed to max value of Read Buffer Size to 65536 bat bat nothing
>> is changed.
>> Please can you try this example?
>> Procedure OnClick
>> Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=DITTE" as 201
>> Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=UTENTI" as 202
>> Open "DFBTRDRV:btrv://localhost/DITTA001PSQL?table=ANAMAG" as 203
>> CLOSE 201
>> CLOSE 202
>> CLOSE 203
>> Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=DITTE" as 201
>> Open "DFBTRDRV:btrv://localhost/DATICOMPSQL?table=UTENTI" as 202
>> Open "DFBTRDRV:btrv://localhost/DITTA001PSQL?table=ANAMAG" as 203
>> CLOSE 201
>> CLOSE 202
>> CLOSE 203
>> End_Procedure // OnClick
>> With this procedure I have the same error with message CLOSING FILE.DDF
>> I have attached the log file pvsw.log
>> What I can do?
>> Regards
>> Giuseppe Catania
>>
>>
>>
>> "Martin Moleman" <martin.moleman@dataaccess.nl> ha scritto nel messaggio
>> news:xGpSkSn7FHA.3872@dacmail.dataaccess.com...
>>> Giuseppe,
>>>
>>> Subtract 21000 from the error number and lookup the error code in the
>>> Pervasive help. So in this case lookup error 3006.
>>> Also check the pvsw.log for possible additional information.
>>>
>>> Regards,
>>>
>>> Martin Moleman
>>> Data Access Europe
>>>
>>>
>>>
>>> "Giuseppe" <info@easyaccess.it> wrote in message
>>> news:PE2IXHX7FHA.3660@dacmail.dataaccess.com...
>>>> To DAC,
>>>> I am trying DATABASE_MODE = 1
>>>> After the uprade of the my applications with the new method I have some
>>>> errors.
>>>> An error is 24006 which i not finded on documentation.
>>>> For Your tests you may try the attached example test2.vw.
>>>> In the test2.vw I open some TABLE of some DATABASE.
>>>> Create 2 DATABASE and some TABLE (see the comments in then view)
>>>> Compile the view and run it.
>>>> Click more time on the button, It show error 24006
>>>>
>>>> Regards
>>>> Giiseppe Catania
>>>> EasyAccess s.a.s.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>>
>
>