Pervasive Community Site

CheckDB for v11

Paul — Mon, 18 Jul 2011 16:23:06 GMT

Does anyone know if there is or if there is going to be a CheckDB for v11?

My reason for asking is we regularly use the CheckDB in v9 to rebuild the RI when renaming databases.

ADO.NET Provider Fails When Using Parameters with Owner Name Table

mattwilkinson — Tue, 21 May 2013 15:50:05 GMT

I am trying to perform a query using the Pervasive.Data.SqlClient.dll (4.0) with parameters It works fine using parameterised queries until I try and perform a query on a table that has the ownername set. I tried switching to ODBC and this works with basically the same code, so I think this is an issue with the provider. This code works:

Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click Dim ds As New DataSet Dim query As String = String.Format("SET OWNER = '{0}';SELECT * FROM Users WHERE UserName = ?", _ownerName) Dim conn As OdbcConnection conn = New OdbcConnection("Driver={Pervasive ODBC Client Interface};ServerName=SMITHERS;dbq=@CAPTUREIT;UID=Master;PWD=;") conn.Open() Dim dataadapter As New OdbcDataAdapter Dim cmd As OdbcCommand = conn.CreateCommand cmd.CommandText = query Dim prm As New OdbcParameter prm.ParameterName = "@UserName" prm.DbType = DbType.String prm.Direction = ParameterDirection.Input prm.Value = "Dave" cmd.Parameters.Add(prm) dataadapter.SelectCommand = cmd dataadapter.Fill(ds) conn.Close() dgvData.DataSource = ds.Tables(0) End Sub

This Code Fails:

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim ds As New DataSet Dim query As String = String.Format("SET OWNER = '{0}';SELECT * FROM Users WHERE UserName = ?", _ownerName) Dim conn As PsqlConnection conn = New PsqlConnection("Server Name=SMITHERS;Database Name=CAPTUREIT;User ID=Master;Password=;TimeType=TimeSpan;") conn.Open() Dim dataadapter As New PsqlDataAdapter Dim cmd As PsqlCommand = conn.CreateCommand cmd.CommandText = query Dim prm As New PsqlParameter prm.ParameterName = "@UserName" prm.DbType = DbType.String prm.Direction = ParameterDirection.Input prm.Value = "Dave" cmd.Parameters.Add(prm) dataadapter.SelectCommand = cmd dataadapter.Fill(ds) '<<

Database Vendor Code -5009 while running Crystal Reports XI and Pvsw v11 64bit

ira — Tue, 21 May 2013 21:52:09 GMT

We are receiving a database connector error and a database vendor code: -5099 when running some crystal reports after upgrading the pervasive to v11 64bit.

We currently do not receive the errors when running in v10 32bit.

Has anyone ever seen this before or have any ideas how to resolve the connection issues?

Pervasive client v10 performance issue on Server 2008 R2 Ent. - with RDS (terminal services)

bozagroza — Tue, 21 May 2013 22:20:30 GMT

We have a problem with Sage Timberline performance after porting it to Win 2008R2 Enterprise - we narrowed the issue is in Pervasive v10

We have Win server 2008 R2 Enterprise with terminal services - pervasive workgroup client 10.30 installed. server has 16GB of RAM and we are testing the app with 3 -4 users load at any given time.

We have Win server 2003 x64 Enterprise - pervasive workgroup server 10.30 installed.

Users were, so far, using XP workstations with 10.30 client installed and are getting responses from Sage Timberline application in the range of 10 -15 seconds to open a screen or a wizard.

What we have been seeing is that, on2008 R2 terminal server response is around 4 seconds for a few days - then it drops to about 30 secs at some point and stays there.

We've been mucking around with Local engine memory settings, trying system cache, max microkernel to 0, OR, no system cache, max microkernel to 60, increasing Cache Allocation size to match the server (409MB), or even bigger. we have limit set to 2GB on both server and client.

the logs show the following:

5/14/2013 9:11:43 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3131: Reconnect not attempted, AutoReconnect not enabled on either client or server.
5/14/2013 9:11:43 AM        MKDE            3616     w3dbsmgr.exe    ARPRDS3         W     Cache engine failed to communicate with server arpistl, error=3111
5/14/2013 9:11:48 AM        MKDE            3616     w3dbsmgr.exe    ARPRDS3         W     Cache engine failed to communicate with server arpistl, error=3110
5/14/2013 9:57:21 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3112: Status 0 returned while receiving a maximum of 65153 bytes.
5/14/2013 9:57:21 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3112: Status 0 returned while receiving a maximum of 65153 bytes.
5/14/2013 9:57:21 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3112: Status 0 returned while receiving a maximum of 65153 bytes.
5/14/2013 9:57:23 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3112: Status 0 returned while receiving a maximum of 65535 bytes.
5/14/2013 9:57:23 AM        MKDE            3616     w3dbsmgr.exe    ARPRDS3         W     Cache engine failed to communicate with server arpistl, error=3112
5/14/2013 9:57:25 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3111: Status 10053 returned while sending 184 bytes.
5/14/2013 9:57:25 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3131: Reconnect not attempted, AutoReconnect not enabled on either client or server.
5/14/2013 9:57:25 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3111: Status 10053 returned while sending 202 bytes.
5/14/2013 9:57:25 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3131: Reconnect not attempted, AutoReconnect not enabled on either client or server.
5/14/2013 9:57:27 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3111: Status 10053 returned while sending 214 bytes.
5/14/2013 9:57:27 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3131: Reconnect not attempted, AutoReconnect not enabled on either client or server.
5/14/2013 9:57:28 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3112: Status 0 returned while receiving a maximum of 65535 bytes.
5/14/2013 9:57:31 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3112: Status 0 returned while receiving a maximum of 65153 bytes.
5/14/2013 9:57:31 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3111: Status 10053 returned while sending 132 bytes.
5/14/2013 9:57:31 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3131: Reconnect not attempted, AutoReconnect not enabled on either client or server.
5/14/2013 9:57:33 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3111: Status 10053 returned while sending 76 bytes.
5/14/2013 9:57:33 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3131: Reconnect not attempted, AutoReconnect not enabled on either client or server.
5/14/2013 9:57:33 AM        MKDE            3616     w3dbsmgr.exe    ARPRDS3         W     Cache engine failed to communicate with server arpistl, error=3111
5/14/2013 9:57:38 AM        MKDE            3616     w3dbsmgr.exe    ARPRDS3         W     Cache engine failed to communicate with server arpistl, error=3110
5/14/2013 9:57:43 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3111: Status 10053 returned while sending 76 bytes.
5/14/2013 9:57:43 AM        W3NSL           3616     w3dbsmgr.exe    ARPRDS3         I     3131: Reconnect not attempted, AutoReconnect not enabled on either client or server.
5/14/2013 9:57:43 AM        MKDE            3616     w3dbsmgr.exe    ARPRDS3         W     Cache engine failed to communicate with server arpistl, error=3111
5/14/2013 9:57:53 AM        MKDE            3616     w3dbsmgr.exe    ARPRDS3         W     Cache engine failed to communicate with server arpistl, error=3110

ARPRDS3 is the client, terminal server, ARPISTL is the server.

I can tell that the error points to WINSOCK timeout - but no idea why it is happening.

The ARPISTL, server, logs show nothing during this time frame.

The only thing we can say for sure is that when the w3dbsmgr.exe on client reaches a certain amount of memory (and that seems to be in the higher range of its Cache Allocation size - the slowdown and the above erros occur.

Any idea where to go from there?

Thanks,

Darko

need help to generate extract

guru.4me — Tue, 21 May 2013 13:57:37 GMT

Hi, I am new to pervasive, please help to find some good document for data integration v10 and I need help in the following issue: I need to generate extract by runing query. the source will me sqlserver 2008 and output will be file. I done creating the source with sqlserver2008 and able to see the result from the table.but when i try to create target with the ascii for flat flie , i not able to generate the extract. Please help me.. Thanks, Gurpreet Singh

Managing DDF for btrieve files with owner ?

OReubens — Tue, 21 May 2013 12:58:48 GMT

I'm having the following issue.

For a project where all files are managed through the btrieve interface / MKDE. We want to create/manage a named database so customers have access to their data via ODBC.

I can create/update/date a named database and add/drop tables for Btrieve manages files. But not if the files have an owner set to them (BUTIL -setowner).
PvAddTable3 fails with returning 1 (PCM_errFailed), and similarly querying the named database via PvGetTableStat2 fails with returning 1 (PCM_errFailed).

Neither PvAddTable3 nor PvGetTableStat2 seem to have any means to provide an owner.

If I remove the owner everything works as expected, but the owner is there for a reason of course. :)

How are we supposed to to use DTI to add tables to a named database for already existing files with owner ?

Auto reconnect on Linux

Ruudunit4 — Thu, 16 May 2013 13:05:07 GMT

Hi,

With autoreconnect enabled on the psql 11 linux server and client our customer still notices this error log message:

16-5-2013 14:21:15 W3NSL 4144 Diamant.exe LT-15 E 3131: Reconnect not attempted, AutoReconnect not enabled on either client or server.

Please tell me that this article about psql 2000i is outdated for psql 11 10 years later...... http://www.pervasivedb.com/kb/Pages/00014742.aspx

If not... houston we have a problem......

Kind regard,

Ruud Herrewijnen

UNIT4.

Error Getting Started with Entity Framework

mattwilkinson — Mon, 20 May 2013 10:10:51 GMT

I am trying to connect to an existing pervasive database using MVC and the Entity Framework. My Model class is defined as follows: Public Class Employee Public Property ClockNo As Int32 Public Property Surname As String Public Property FirstNames As String End Class I get the following error: Schema specified is not valid. Errors: (7,6) : error 0040: The Type int32 is not qualified with a namespace or alias. Only primitive types can be used without qualification My connection string is as follows:

Delta files remains after end continuous mode

santhoshatvembu — Sun, 19 May 2013 14:26:26 GMT

Hi all, I was implemented BTRCALLID functions to put the active files into continuous mode and after backed up the pervasive databae files I have ended the continuous mode. It works normally when our application runs. But when suppose our application crashed / killed after begin continuous mode without ending, the delta files remain in same location which results continuous mode fails in next schedule... I have tried to handle this by calling BTRCALLID function for ending continuos mode when our application get killed. But the function returns the value 0 states success but still delta files remain in same location. Is anything else I have missed..? Is that client ID passed differs with thread.? Please help me to understand the continuous mode operations better.

How to dinamically change Target and Source

ribeiro_pires@yahoo.com — Tue, 24 Jan 2006 18:01:48 GMT

I have a Map, called inside a Process. That Map uses variables passed by the Process. I need a way to dinamically change the Target Connect String and the Source Connect String dinamically. I want to pass from the Process to the Map variables for dinamically create a Connection String.
I try to put in Transformation Events (Before Transformation) a ChangeTarget and a ChangeSource (in this order).
But it didn't work. It changes the Source but not the Target.

Does Anybody know how to do this?

How to convert FLOAT into fixed decimal string?

PSi — Wed, 08 May 2013 06:20:00 GMT

I'm trying to join currency amounts with three letter currency labes so that FLOAT currency ammounts would have rounded fixed two decimal places to give neat appearance when aligned right, like:

F --------- 14.00 EUR 4.00 USD 0.80 USD 4.00 GBP 90.80 YEN ---------

For demo I'm using the Demodata that comes with PSQL 11. I use "Student" table's two columns:

CUMULATIVE_GPA Decimal(4) MAJOR CHAR(20)

so you can verify what I'm trying to do.

I tried to use cast and convert functions but am unable to get the results I expect:

select top 5 Cumulative_GPA A, cast(Cumulative_GPA AS DECIMAL(6,2)) B, cast(cast(Cumulative_GPA AS DECIMAL(6,2)) AS CHAR(9)) C, convert(cast(Cumulative_GPA AS DECIMAL(6,2)), SQL_VARCHAR) D, Major E, convert(cast(Cumulative_GPA AS DECIMAL(6,2)), SQL_VARCHAR) + ' ' + Major F from "Student"

It yelds:

A B C D E F ----- ---- --- --- ---------- ------------- 4.000 4.00 4 4 Economics 4 Economics 4.000 4.00 4 4 Spanish 4 Spanish 0.800 0.80 .8 .8 Chemistry .8 Chemistry 4.000 4.00 4 4 Economics 4 Economics 0.801 0.80 .80 .80 Sociology .80 Sociology ----- ---- --- --- ---------- -------------

I expected column F to yeld:

F --------------- 4.00 Economics 4.00 Spanish 0.80 Chemistry 4.00 Economics 0.80 Sociology ---------------

Am I missing something obvious? How I can get the results I expect? Is there perhaps a bug in PSQL's convert(cast(...)) combination? Using clumn B and column E and joining the data afterward is not an acceptable solution.

pekka

Di and Agent don't sync Up

Dize — Mon, 20 May 2013 08:43:55 GMT

What are the possible reason and resolution:

i'm running the same package with the same data and Macro in Di and agent, yet i'm still getting different result when running them

Re: Apps are much slower on 2008 64 bit terminal server vs 2003 terminal server

Wayne Wagstaff — Tue, 05 Feb 2013 14:27:14 GMT

[Michael Beris] Thread split from http://cs.pervasive.com/forums/t/12342.aspx by request.

For context, see http://cs.pervasive.com/forums/t/12342.aspx

Hi!

I can confirm the same - it is happening the same in our company.

W2k3 32bit is 3-4 times faster than W2k8 64bit.

Has anybody resolved this issue?

I would very much appriciate any info on this.

BR, Smiljan

32 bit ODBC on 64 bit Debian

RogerIrwin — Tue, 14 May 2013 17:29:29 GMT

Hi, I'm trying to run a Mono application which must connect to a Pervasive database. There is a 32 bit ODBC driver which I tried successfully on a 32 bit Ubuntu 12.04. But I really need to be running this on 64 bit Debian 7.0 systems. I installed the client package, and the pcc tool works fine. ODBC from mono does not, and the debug info tells me that libodbc cannot be found. I do have ia32-libs installed. I do have a 32 bit libodbc.so.1.0.0 in /usr/lib/i386-linux-gnu, and another in the psql client package (/usr/local/psql/lib/libodbc.so.1.0.000), which 'file' also reports as being 32 bit. Now I have configured /etc/mono/config and used ldconfig and everthing else I can think of, and ldd tells me that the libraries dependicies are met...and yet mono runtime contunues to not find the package. I also checked file permissions. So I tried isql, and that reported (immediately) that there was no SQL connect. Any ideas gratefully received!

DJImport Script Object Causing Max Cursor Error

rnault — Thu, 09 May 2013 19:12:40 GMT

My client has created RIFL script code to perform a validation lookup for each record using a DJImport object to perform a SQL query lookup to see if the item already exists in the destination database. Just recently the Pervasive Process is generating an Oracle database error 604 and 1000 max cursors reached. Pervasive v9.2.5.86 Oracle 11g database Any suggestions on how to solve this issue? The data is around 25,000 records. --------------------------- Code Example: set ValidateItem_Obj = New DJImport = "Oracle 11g" ValidateItem_Obj.ConnectString = ("Database=GOLD; UserID=user; Password=password; Table=ARTRAC; Encoding=OEM; WhereStmt =; SystemTables=False;Views=True; Synonyms=False;QueryRewrite=Enforced;ParallelHint=0") ValidationItem_Obj.SQLStatement = ("select * from ARTRAC" where item = '") & ITEM_NO & "')" ValidateItem_Lookup = ValidateItem_Obj.Fields(1) Thanks, Ray

Len function

kelapa — Sat, 11 May 2013 08:16:48 GMT

How to get a max length of a field's cell in a table?

UpprCase.Alt file request

wcjenkinsjr — Mon, 13 May 2013 19:51:35 GMT

Help Please. What I think I need is the UpprCase.Alt file, but cannot locate it. Can anyone help with this file and/or solutions to work around? Thanks to any one who can help. WCJJr I am attempting to create DDF tables from a Btrieve file ins_co.dat, that when opened by DDF Builder, yield’s an error when saving the file. I have talked to support, and they suggest that the vendor of the program should provide the UpprCase.Alt file. I have checked the servicer, work station, and support without any luck. Additionally, when I contacted PracticeWork, they responded that this request is outside of the support purview provided. Here is a recording of the SQL statement that of the attempted save: Hello, Wilbert Jenkins' create table, and I am running PSQL WorkGroup engine and the DDF Builder directly on the machine where the PSQL engine is running. CREATE TABLE "ins-co" IN DICTIONARY USING 'ins-co.DAT' ( "InsCoID" INTEGER NOT NULL, "InsCoName" VARCHAR(35) NOT NULL COLLATE 'UPPRCASE.alt', "InsCoAddress1" VARCHAR(35) NOT NULL COLLATE 'UPPRCASE.alt', "InsCoAddress2" CHAR(36) NOT NULL, "InsCoCity" CHAR(16) NOT NULL, "InsCoState" CHAR(4) NOT NULL, "InsCoZip" CHAR(11) NOT NULL, "InsCoPhone" CHAR(20) NOT NULL, "InsCoFax" CHAR(20) NOT NULL, "InsCoContactName" CHAR(36) NOT NULL, "ElecClaimsID" CHAR(17) NOT NULL, "ECFilingName" CHAR(36) NOT NULL, "GroupNumRequired" LOGICAL NOT NULL, "TrackECasPaper" LOGICAL NOT NULL, "FormFileName" CHAR(13) NOT NULL, "TrogenCarrierCode" CHAR(7) NOT NULL, "MedicaFormName" CHAR(13) NOT NULL, "UserTypeID" INTEGER NOT NULL, "Inactive" LOGICAL NOT NULL, "TrogenMCAdminCode" CHAR(8) NOT NULL, "PrecedeADACode" LOGICAL NOT NULL, "ADACodeChart" CHAR(1) NOT NULL, "PrintDocSigOnFile" LOGICAL NOT NULL, "LastUpDatedDate" DATE NOT NULL, "FeeSchedule" INTEGER NOT NULL, "UsesCurADASet" LOGICAL NOT NULL, "ShrinkToFit" LOGICAL NOT NULL, "CodeSetAccepted" SMALLINT NOT NULL, "NEAMasterID" CHAR(7) NOT NULL, "ERACapable" LOGICAL NOT NULL, "Filler" CHAR(8) NOT NULL, "Spare" CHAR(4) NOT NULL); SET TRUENULLCREATE = ON; CREATE UNIQUE INDEX "index_0" IN DICTIONARY ON "ins-co" ( "InsCoID" ); CREATE INDEX "index_1" IN DICTIONARY ON "ins-co" ( "InsCoName" , "InsCoAddress1" ); Additionally, I have included create table information at the time of the error. File Statistics for c:\wcjjrdatafoldereds\datapracticeworks\ins-co.dat File Version = 9.50 Page Size = 4096 Page Preallocation = No Key Only = No Extended = No Total Number of Records = 710 Record Length = 355 Record Compression = No Page Compression = No Variable Records = No Available Linked Duplicate Keys = 0 Balanced Key = No Log Key = 0 System Data = No Total Number of Keys = 2 Total Number of Segments = 3 Key Position Type Null Values* ACS Segment Length Flags Unique Values 0 1 1 4 Integer M -- 710 -- 1 1 5 36 Zstring MD -- 681 0 1 2 41 36 Zstring MD -- 681 0 Alternate Collating Sequence(ACS) List: 0 UPPRCASE Legend:

ntdbsmgr64 crash on Alter Table

Opal — Mon, 13 May 2013 13:01:51 GMT

I get ntdbsmgr64 crash when executing following SQL:

ALTER TABLE "Table" ADD "AutoInc" IDENTITY NOT NULL.

Size of the table is approx. 1.2 GB. I've tried this on v11 SP2 and v11 SP3 update 1 on Win7 and on Win 2008. It was also tested on v10 and it worked fine. SQL statement

ALTER TABLE "Table" ADD "AutoIncGl" INTEGER DEFAULT 0 NOT NULL

works fine. I tried increasing Cache allocation size to 10000 MB but it didn't help (per Task Manager ntdbsrmgr64 was using approx. 5.5 GB of memory before crashing).

Any ideas what can be wrong?

Re: Setup ODBC to PSQL on Ubuntu Linux

Brasse — Mon, 26 Sep 2011 11:33:38 GMT

Im having some problems connecting with PHP5(apache) and i wonder if someone can help me?

My server is running Ubuntu Linux 10.04.2 LTS(64 bit) Apache2 and PHP5.

This is how i installed:
sudo apt-get install ia32-libs
cd /usr/local/
cp /home/brasse/Pervasive.SQL-Client-10.30-024.000.i486.tar.gz .
tar -zxf Pervasive.SQL-Client-10.30-024.000.i486.tar.gz
cd psql/etc/
sh clientpreinstall.sh
sh clientpostinstall.sh

## ive put following in /etc/apache2/envvars
umask 022
export PVSW_ROOT=/usr/local/psql
export PATH=$PVSW_ROOT/bin:/bin:/usr/bin

if [ $(uname -s) = "Darwin" ]
then
export DYLD_LIBRARY_PATH=$PVSW_ROOT/lib:$PVSW_ROOT/lib64:$PVSW_ROOT/bin:/usr/lib
else
export LD_LIBRARY_PATH=$PVSW_ROOT/lib:$PVSW_ROOT/lib64:$PVSW_ROOT/bin:/usr/lib
fi

export MANPATH=$PVSW_ROOT/man:$MANPATH
export BREQ=$PVSW_ROOT/lib
export LD_BIND_NOW=1
##################################################

usermod -a -G pvsw www-data
/usr/local/psql/bin/dsnadd -dsn=ODBC -host=ernst -sdsn=ODBC
echo "/usr/local/psql/lib" > /etc/ld.so.conf.d/psql.conf
ldconfig

service apache2 restart

When i try this. it works good:

?php
echo shell_exec('isql -v ODBC');
?>

but when i do it like this:

?php
$conn = odbc_connect("ODBC","","");
echo $conn;
?>
i get this error message:
Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Can't open lib '/usr/local/psql/lib/odbcci.so' : file not found, SQL state 01000 in SQLConnect in /var/www/test/index.php on line 35

How can i solve this? (i will put my complete installation procedure here when im done, so it can help others when im done)

ps.
ive tried running from CLI as well:

psql@albin:/var/www/test$ php5 index.php (same file..)
PHP Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Can't open lib '/usr/local/psql/lib/odbcci.so' : file not found, SQL state 01000 in SQLConnect in /var/www/test/index.php on line 36
psql@albin:/var/www/test$ isql -v ODBC -- this works though...

Create User Defined Function in sql

dblwizard — Fri, 10 May 2013 15:02:21 GMT

Howdy,

Is there any way to create a User Defined Function from an sql script or is the only way to use the Control Center and click "New ..." for each function that needs to be added?

Thanks

dbl

Very slow opening av transactional (btrieve) file with unc-path and DB-auth.

GoranL — Sun, 26 Oct 2008 21:01:58 GMT

Hi
We have two customers which have very badly slow performance to open a btrieve (transactional file) with unc-path.

They have Pervasive 10.12 clients on Windows XP and the server is Pervasive 10.12 server on Windows 2003 Std. Edition.

It is only slow then they is NOT logged in (authorized) to the server-OS. (the server is not in any row with the command "net use").

We have successfully reproduced the problem (we think). It is done if the install an Novell Netware client 4.91 sp3 or 4.91 sp4. (not checked with 4.92).

We found these links and the possible solutions, but nothing of that has helped us.
Now we must have some help from you out there in cyberspace. Du You think the problem is the Novell client? Has anybody had the same problem and how do You solved it? Why did the Pervasive client care of/speak with the Novell client? Is it an old thing from the time then Novell anv Btrieve/Pervasive went hand-in-hand?

http://www.pervasive.com/kb/kb.asp?fx=getdetails&solid=00015826&title=Poor%20Performance%20on%20the%20Network%20with%20NetWare%20and%20Windows%20NT%20Servers%20using%20%20Pervasive.SQL

http://support.novell.com/cgi-bin/search/searchtid.cgi?/10090785.htm

http://support.novell.com/cgi-bin/search/searchtid.cgi?/10052031.htm

1000+ Input/Output Threads, safe option or not?

Ruudunit4 — Fri, 10 May 2013 09:13:03 GMT

Hi,

One of our customers has experienced a significant lower performance when they exceed 200 users. This server has 300 gb L1 cache and very fast disk performance. Input/Output threads is at 128 at the moment. This value was once advice by Bruno Kerdoncuff in the good old PSQL 32 bit days. We never thought of changing this value because the cpu and network was always the bottleneck here.
Now we see that the users experience slower performance while the system load is still low. Input/Output threads could be the bottleneck now. At peak moments 9600 files are open.

Two questions.

1. Are the IO's also used to access files that are already in L1 cache?

2. Does anyone have experience with IO thread values above 1000?

Ruud Herrewijnen

Senior technician UNIT4 FI Servicedesk.

Re: Creating database by DTO2.DLL works in Pervasive 9 but NOT in 10

bhushan.nankar — Fri, 10 May 2013 06:41:43 GMT

Hi, Please let me know the link to download DTO2.dll Thanks, Bhushan

[Michael Beris] Post split due to age of original post.

NullPointerException After Upgrade to SP3 on v11

mattwilkinson — Mon, 18 Mar 2013 14:31:37 GMT

Normal 0 false false false EN-GB X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";}

PSQL v11 after upgrade to SP3 Windows 7 (but also seen on Windows XP). Both Workgroup and Client Server

Open Pervasive Control Center - right click on certain tables (job batches, job sequences) and select Edit them I get an Error "Unexpected Error Occurred: NullPointerException". Other tables (e.g. Jobs are fine)

Can pervasive wait .exe execution ?

superrian — Tue, 07 May 2013 00:42:51 GMT

Hi everyone, I have a problem. I use process designer to execute .exe file through "application" fiture (use icon "EXE" on process step bar). I need to wait the execution file before continue the next process. Could pervasive do that ? the actual condition is that pervasive continue the next process without waiting the process of .exe file execution is finished. thank you, Regards,