×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Workgroup engine and client conflict

Workgroup engine and client conflict

Workgroup engine and client conflict

(OP)
Hi fellows,

    I have two applications that run against Pervasive SQL, at the begining both were installed independently in different servers and different clients (users). The first one was running against Pervasive SQL 2000 (using the client) and the second (Business Works Gold) was running against Pervasive SQL 2000i (using the workgroup engine).

    As we need to allow several users to run both applications I tried to install both clients in the same machine but couldn't make both work simultaneously.

    In another post in this forum I was told to make both applications run against Pervasive SQL 2000i as this is a minor upgrade from Pervasive 2000 and so I did. The databases are now both on Pervasive 2000i. However, I can´t make the client and the workgroup engine work simultaneously.

    Does anyone have an idea of what can I do? I'm very ignorant and confused about Pervasive SQL connection architecture so a clear explanation of the situation would be very very helpful.

    Thanks a lot,

Mauricio Peccorini

RE: Workgroup engine and client conflict

What problem are you having?  The WOrkgroup engine includes components that allow it to act as a client for remote data when that data is on a server with the server engine.  
Are you getting errors?  
If so, what errors?
Have you tried just using Pervasive (eliminating the apps for the sake of testing)?  

 

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: Workgroup engine and client conflict

(OP)
As you advised in another thread, I migrated my database from Pervasive 2000 to Pervasive 2000i and using the Pervasive 2000i client it worked well.

After that I installed the second application (Business Works) and as it requires the Workgroup Engine eventhough we are using a server engine I installed that. After the Workgroup Engine installation the first application started reporting an error code 11 (invalid file but I can open the file from other clients) when trying to open the first table. After I rebooted the client machine it started reporting an error code 8020 (error loading component). Documentation states PVSW\BIN should be included in the PATH enviroment variable and it effectively is included.

Sorry I didn´t explain all this behaviour in the first post. I see it would have been helpful but I thought my situation was very common.

Thanks for the help,

Mauricio Peccorini

RE: Workgroup engine and client conflict

For the status 11, the application is probably looking for the files in a specific location and you need to make sure they are there.  
For the 8020, post the PVSW.LOG from the machine getting the status 8020.  It should be in the WINDOWS directory.  
Also, do any of the Pervasive tools (PCC, Function Executor, etc) work?  If so, then start them and then try the app.  Does it still get the 8020?  If not, then it's a path issue.  

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: Workgroup engine and client conflict

(OP)
New facts:
- error 8020 is not showing anymore (I have no idea why)
- the first attempt to open a table fails with error 12 reporting the file's path and name (N:\PL-CCC\CP-TABLA.DTA). I double checked and the network mapping is in place (also tried connecting the network mapping as the servers administrator) and the file is in the correct path.
- sucessive attempts to open files report error code 12  but the files are again in the correct path
- PVSW.LOG is not showing anything but type I (information) messages.

Thanks so much for your help, but I'm kind of loosing hope with this issue,

Mauricio Peccorini

RE: Workgroup engine and client conflict

Can you open the file (N:\PL-CCC\CP-TABLA.DTA) usign the FUnction Executor?  Does it give a status 12?  

As a last resort, have you contacted the vendors?  

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: Workgroup engine and client conflict

(OP)
Both PCC and Function Executor work fine, the application vendor... useless :-(

RE: Workgroup engine and client conflict

(OP)
I have enabled microkernel's trace and here is the result

It is kind of cryptic but you can see the table's name and the operation's result. It appears to me that there are some spaces and strange characters after the file's name, is that normal?



<In> 0016   Opcode : 0000   Crs ID : 0xffffffff  Db Length : 00001   Keynum : 00   Clnt ID : FF FF FF FF 00 00 C0 A8 70 9F 05 9E 57 52 88 02  Clock : 0006d444  Time : Fri Jun 18 12:00:01 2004
DBuf:       4e 4f 54 53 48 4f 57 4e - 00                        NOTSHOWN.       
KBuf:       5c 5c 54 61 67 2d 63 63 - 63 2d 64 62 2d 30 30 31   \\Tag-ccc-db-001
            5c 54 58 54 4c 5c 50 4c - 2d 43 43 43 5c 43 50 2d   \TXTL\PL-CCC\CP-
            54 41 42 4c 41 2e 44 54 - 41 20 20 20 20 20 20 20   TABLA.DTA       
            20 20 20 20 20 20 20 20 - 20 20 20 20 20 20 20 20                   
            20 20 20 20 20 20 20 20 - 20 20 20 20 20 20 20 20                   
            20 20 20 c3 84 04 00 02 - 00 00 50 19 bd 00 d0 bf      Ã„.....P.½.п
            c0 80 17 b4 f7 23 5d d4 - 22 5b de 96 06 b5 06 2d   À€.´÷#]Ô"[Þ–.µ.-
            c9 d9 09 ee 57          -                           ÉÙ.îW           
File:       "\\Tag-ccc-db-001\TXTL\PL-CCC\CP-TABLA.DTA                                          Ä"

<Out>0016   Status : 0011   Crs ID : 0x00000000  Db Length : 00001   Keynum : 00   Clnt ID : FF FF FF FF 00 00 C0 A8 70 9F 05 9E 57 52 88 02  Clock : 0006d444  Time : Fri Jun 18 12:00:01 2004
DBuf:       4e 4f 54 53 48 4f 57 4e - 00                        NOTSHOWN.       
KBuf:       5c 5c 54 61 67 2d 63 63 - 63 2d 64 62 2d 30 30 31   \\Tag-ccc-db-001
            5c 54 58 54 4c 5c 50 4c - 2d 43 43 43 5c 43 50 2d   \TXTL\PL-CCC\CP-
            54 41 42 4c 41 2e 44 54 - 41 20 20 20 20 20 20 20   TABLA.DTA       
            20 20 20 20 20 20 20 20 - 20 20 20 20 20 20 20 20                   
            20 20 20 20 20 20 20 20 - 20 20 20 20 20 20 20 20                   
            20 20 20 c3 84 04 00 02 - 00 00 50 19 43 43 43 2d      Ã„.....P.CCC-
            4d 50 45 43 43 4f 52 49 - 4e 49 5c 6d 70 65 63 63   MPECCORINI\mpecc
            6f 72 69 6e 69          -                           orini           


RE: Workgroup engine and client conflict

That can be normal.  What you should do now is run the trace on a working machine. Then compare the Open that works with the one that fails to see where the difference is...

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

RE: Workgroup engine and client conflict

(OP)
Thanks for your help Mirtheil, effectively those spaces where what was wrong. I found out that you can control them by setting Configuration->Client->Application Characteristics->Embedded Spaces to Off.

Now both applications are working fine. I still don't know exactly what the setting is for, I guess it should be allways off but nevermind.

Thanks a lot anyway,

Mauricio Peccorini

RE: Workgroup engine and client conflict

I have a very similar problem... Im using Pervasive v8.5.


The two applications I have are ACCPAC(an old version) and the latest (Jul) build of Maximizer.

One server hosts the data for both these.

ACCPAC wants the client engine, but when I install maximizer it removes the client engine and uses the workgroup engine.  However, when I use the workgroup engine, Maximizer is REALLY really slow.  So then I have to re-install the client engine over top, but employees complain of errors in maximizer every few hours.

Any thoughts?

Errors are error 3012, error 3, error 171

-Ben

RE: Workgroup engine and client conflict

BenF,
You really should start a new thread rather than dig this one up.  
What do you mean by "Client Engine" and "Workgroup Engine".  What versions are the two programs using?  
A 3012 means: Local engine is not accessible to the MicroKernel router (basically, the app is trying to open a file locally but can't find an engine or the app can't communicate with a server engine and then can't find a local engine).  
THe status 3 is "File not open" and would be expected after a 3012.  
The 171 means "Database login failed" and "Authentication to the database failed due to a wrong or missing password." This is most likely an application issue or a user issue.

 

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

RE: Workgroup engine and client conflict

Client Engine and Workgroup Engine - These are two of the three engines pervasive offers.


I understand their are three offerings in v8....I found this information on the pervasive.com site

Pervasive v8 Server
Pervasive v8 Client (requester)
Pervasive v8 Workgroup

(All versions of Pervasive are v8.4.  We use Maximizer 8, build 1425 and ACCPAC Small business series 4.2a)

The first two are meant to work hand in hand of course.

My understanding is that you can install one of these on any given machine, and no more.  I am a little confused why the Maximizer Enterprise 8 Workstation CD installs the Workgroup engine, and not the Client Engine.  



-Ben

RE: Workgroup engine and client conflict

The Workgroup Engine allows remote and local access. The CLient Engine only allows access to a remote machine (no local access).  Maximizer installs the WGE because it probably needs to access files locally on the machine.  THe WGE has the same "client" components as the Client (requester).  
I'm not aware of an 8.4 release of Pervasive. I know of 8.0, 8.1, 8.5, and 8.6.  WGE, client, and server should be at the same patch level to function correctly.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.
http://www.mirtheil.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close