Solidworks pcb services не работает

How to install SOLIDWORKS PCB Services

Article by Joseph Lyon updated January 13, 2018

Article

SOLIDWORKS PCB is powerful electronic design software that enables the streamlined integration of electrical and mechanical engineering. Collaboration between SOLIDWORKS and SOLIDWORKS PCB is managed through a program known as the PCB Services. PCB Services utilizes the Microsoft Internet Information Services (IIS) to manage all mechanical and electrical CAD data and change history. Install SOLIDWORKS PCB Services as a separate entity from SOLIDWORKS and SOLIDWORKS PCB, an additional license is not required.

SOLIDWORKS PCB Network Architecture

Installation Requirements

There are two possible setup scenarios to install SOLIDWORKS PCB Services:

1. SOLIDWORKS and SOLIDWORKS PCB Collaboration requirements:
   • SOLIDWORKS PCB
   • SOLIDWORKS PCB Serial Number
   • PCB Services
   • SOLIDWORKS PCB Add-In
2. SOLIDWORKS and Altium Designer Collaboration requirements:
   • Altium Designer
   • Altium Connector Serial Number
   • PCB Services
   • SOLIDWORKS PCB Add-In

It should be noted that the SOLIDWORKS PCB Add-In is what allows the SOLIDWORKS mechanical software to leverage and collaborate with electrical CAD data from SOLIDWORKS PCB or Altium Designer. By default, it is pre-installed with SOLIDWORKS 2016 SP3 and later, it can be installed separately otherwise.

Installation Best Practices

Install SOLIDWORKS PCB Services prior to installing SOLIDWORKS PCB

SOLIDWORKS PCB Services can be found in the SOLIDWORKS installation manager, under Server products installation. It is recommended to install PCB Services prior to SOLIDWORKS PCB and that they are both on the same version.

SOLIDWORKS Installation Manager

Create a backup administrator user

It is good administration practice to create a secondary admin user. In the event you accidently modify or delete your default admin account, a secondary admin user will aid in releasing data.

1. To create a secondary admin account, first log in to PCB Services web interface (http://machinename:9780) as the default admin (username: admin, password: admin). Next, navigate to the USERS tab and click on + Add User.

PCB Services Web User Interface

1. Fill out all required fields. Make sure to fill out the New Roles field, search and assign the role of Administrators.

PCB Services – Standalone vs Server

PCB Services can be installed on a single machine or a shared server. It is not required for PCB Services to be installed on every machine using SOLIDWORKS PCB or Altium Designer. For a multi-user network it is advisable to install PCB Services on a shared server machine, as the PCB Services must always be online. The machine with PCB Services installed must have communication through firewalls and virus protection with all collaborating users.

Installation Guide

For a full step-by-step installation guide, please see the SOLIDWORKS PCB Installation Help.

Источник

Electrical Engineering & Electronics Design

Created by Xgentec Jason on 11 April, 2018

Solidworks PCB Failed to retrieve user. Error retrieve data from database

Share this awesome discussion with your friends

Social

Copy link

I was forced to do a clean install of windows 10 after a system crash of biblical proportions. I then restarted the reinstall of all software to its original state however this is when the new nightmare began. After hours of crawling through the jungle of software installation it was time for the final solution of SOLIDWORKS reinstall. With a sweating brow I hit the install button. After what seemed like hours and a large puddle of sweat growing in the floor the cpu core sent a message. Installation has finished . After a small session of jumping around the room shouting I am the best I then decided to install the final stage the Solidworks PCB services so I could start my legendary circuit design skills. By this time I had consumed an entire bottle of wine, very late at night glowing in my glory I was sitting in my best pair of spandex underpants believing I was unstoppable. All I had to do now was sign in to Solidworks PCB services to complete my mission.

I entered my login details http://localhost:9780/ user: admin password: admin

and then instantly the cpu decided to thrust right back at me with double nut ball punch, I don’t think so moron «failed to retrieve user. error retrieve data from database»

My glory was shattered. Tired, dehydrated, demoralised and may I say quite drunk I retired to my bed hitting my pillow in frustration . So alright then game on baby. I awoke in

the morning and sprang in to action with a new level of determination after an

entire morning of hangover coffee’s and full English fry up and a swift day nap It got to about 5 oclock in the afternoon and I was finally ready. This computer was no match for me. I decide to analyse the situation using my new level of determination and yes I had a new pair of underpants with my power ranger logo on the front. I meant business. In my new found determination and clarity I realised It may be windows 10 that was blocking something even though I turned off windows defender and firewall so I decided to be crafty and transfer all Solidworks install files to a temp folder I created within C:/ drive. Once installed I then I went directly to the Solidworks PCB services folder within the temp folder and ran the PCB services setup as administrator direct from there. This time windows 10 had obviously underestimated my vast superior intellectual capacity wrapped in my power ranger underpants. My mission was finally complete! Login was no match for the superior intellect.

My recommendation is to use a SSD boot drive for windows (i use M.2) and place all apps on another drive (SSD, rotating, whatever).

In addition, place all data on at least RAID level 1 (mirror) with a minimum of 2 drives.

Backups should be daily for heavy workloads and at least weekly for casual workloads. These can be as simple as to USB flash drives.

That should prevent any losses and also minimize any time lost from rebuilds (e.g. RAID) distracting you from productive work.

That is an interesting option Steven, I will look in to that.

I have a couple of spare SSD drives. I normally just do a file system backup.

Having this same issue, as it seems a lot of people have.

And so far, nobody has provided a fool proof truly working fix for this.

I tried installing the pcb services by itself as well, as administrator, and made sure to turn off everything related to firewall/virus/whatever (I’m on a stand along windows10 install that will never be in contact with the net), and I still get that same error, and there is no other info provided to figure out what is really going on.

This is major league B.S.! No end user should ever have to put up with such crap and be forced to dive deep troubleshooting this.

I did try to figure out some more, digging into the log files.

I know the service was installed and apparently up and running, as when accessing it via a browser, I do get its login screen, so it’s serving that, at least. But then when trying the default login, ERROR!

Digging through the numerous logs, most of it being totally irrelevant to the issue, I think I can see that there may be no database created, or perhaps all the tables in that database, so the error, I suspect, it caused by the database tables not existing.

Why do we have to put up with this.

I run those win10 installs as virtual machines, with no network enabled, so I can turn off all protections like firewall and whatever, plus the win10 install is fresh off its installer, with no other apps, and then I just go in there to turn off whatever could interfere, and yet, it still won’t work!

I think it a user privilege issue when installing.

As mentioned above try this:

Transfer all your installation files to a temp folder in C:/ drive.

Then try re installing the solid works installation. or :

I already had solid works installed at this point so I transferred all installation files to temp folder in C:/ drive then simply went to Solid works PCB services folder and ran the PCB services setup.

This worked for me.

Well, just tried it that way and the error is still there.

We shouldn’t have to go digging into logs and more, to troubleshoot and fix what’s been done wrong.

They made a broken installer years ago and have yet to fix it so it runs properly for everyone.

So I’m still stuck with a non functional pcb services, which makes it useless.

Here’s a log snippet that I figured is likely pointing out what type of error it may be:

00:00:52: DEBUG [TID=5580] INFO: —- Testing data source connection.

00:00:52: DEBUG [TID=5580] ERROR: EXCEPTION (EIB_ISCError) at «TDataConnection_Firebird.GetObjects [select first 1 IDS_User.*, IDS_Organisation.Points AS AltiumLivePoints, IDS_Organisation.Name AS Organisation, IDS_Organisation.Active AS OrgActive FROM IDS_User LEFT JOIN IDS_Organisation ON (IDS_Organisation.GUID = IDS_User.OrganisationGUID) where IDS_User.Active = 1;]»: ISC ERROR CODE:335544569

ISC ERROR MESSAGE:

Dynamic SQL Error

SQL error code = -204

At line 1, column 154

00:00:53: DEBUG [TID=5580] INFO: —- Testing access control connection.

00:00:53: INFO OnStart event completed (ServerMode=Plugin)

00:00:53: INFO Startup Completed

That came from the log in the IDS folder in the main logs folder. There are so many, and none are explicit enough in naming, to know what they actually pertain to, so it’s a bit of a shot in the dark.

But in any case, from what I gather, it looks like missing tables, so either an empty database was created but nothing was created in it (tables) or maybe the database wasn’t created at all. I don’t know much about firebird, so I can’t troubleshoot this properly. Too bad they used that open source database that I know nothing about.

Try a system reboot,

Then transfer entire copy of the solidworks installation to C:\

Now go to C:\pcbservices\setup.exe and run as administrator ?

If not work try:

C:\pcbservices\SOLIDWORKS PCB Services.exe and then run as administrator ?

Rebooted many, many many times. Makes no difference whatsoever.

As I mentioned, I went through all the «security» stuff I could find, to disable whatever is there, firewall, anti-virus. you name it.

I need to find what’s preventing the pcb services from working properly, and I did try to copy that part of the install stuff to the main drive in a temp folder and did try running it as admin, and that didn’t change anything.

The pcb services doesn’t depend on anything else to function, and it should be accessible via a browser, which it is, once installed, except that apparently it didn’t properly create its database. That’s what I gather, from logs.

Now if a fresh clean install of win10, followed by a new install of solidworks, with nothing else whatsoever, doesn’t work, obviously something is badly wrong with the solidworks install process. And the part failing to install properly is the pcb services. Everything else installs properly and runs with no issues, just that pcb services that just won’t work.

This is a wide spread issue and many are having it, and I have yet to find the right solution to fix it.

Hello again Didier,

I just wanted to make sure you have done everything you are supposed to.

1. You have installed the main solidworks installation package.
2. Then you restarted the solidworks installer setup and installed the solid works server products (Solidworks PCB Services)

Only tick the Solidworks PCB Services from the server products.

I tried many variations on theme.

I tried first to install solidworks, then add the pcb services afterwards.

Then tried it the other way around. Same difference, same results.

Tried installing only the pcb services and tried accessing it via a browser, to make sure it was responding, which it did, but giving the dreadful error when trying to log in.

Installing from a copy to a temp folder made no difference, and yes, I did start the installer as admin.

Also tried it all again in a fresh virtual machine with a win10 install from scratch, making sure to turn off as many «security» things as possible, hoping that’s what could be interfering. But no luck there.

Having found where the log files are, I’ve been trying to find some useful clues, but so far, all I can see is it seems the database wasn’t created, so as far as I can tell, the error comes from a non existing database/tables..

Tried doing a «repair» with the pcb services installer (the one copied to a temp folder), after having changed an «N» to a «Y» in the installer’s config file for the «LogResults» option, which I was hoping would tell it to log something, at least more than what it’s supposed to be doing.

But it didn’t seem to be logging anything more and although the repair process looked like it worked, it didn’t report any errors, it didn’t fix the issue with the database. In the pcb services logs, in the IDS folder, the logs show that the error seems to be related to missing tables, so I don’t see anything else that could be the real issue. I must assume something goes wrong when it’s supposed to be populating the database, and it doesn’t happen, and why oh why isn’t it reporting this, or at least logging the problem.

I haven’t seen any useful info from googling about this wide spread issue. Many are reporting this same issue, but no fool proof fix posted anywhere. Finding out what the problem really is and posting the fix here would surely help many others.

With so many users having this same issue, and obviously at least some have gotten this fixed somehow, possibly by getting the support folks at SW to point to the problem fix, it’s odd that no actual fix has been posted anywhere.

And I’ve been trying out versions for the past 3 years or so, and although now no more errors are reported during the install process, it still fails to successfully install, so to me it looks like the errors would have just been suppressed but not actually been fixed.

It’s odd that after all this time it’s not fixed.

By the way: One of the «potential» solutions one user had proposed on one of the threads from other user’s posts on that issue, consisting in restarting the firebird server process, followed by restarting the IIS server, doesn’t fix the issue.

Database tables are missing, so I don’t see how restarting the processes would help that.

And I don’t even understand why 2 databases systems are being used. Why use both firebird AND IIS. makes no sense to me. One should suffice.

But hey! Why make things simple when they can be made more complicated.

Hello again Didier,

I would like to dig in to this problem however at the moment I am quite unwell and can not seem to concentrate. I keep wondering if you have some sort of file corruption in your Solidworks PCB Services folder. I am guessing there is not much difference between the new version 2020 solidworks PCB Service and like a 2018 version when it comes to Solidworks PCB Services. You could try a solidworks 2018 copy of Solidworks PCB Services and do a file transplant. Install 2018 PCB services from the c:\ temp folder as admin. Just thinking may be worth a shot. I know solidworks has had issues with installers for years. The main problem I found with solidworks pcb is finding components. It is a nightmare, it used to be linked to altium vault but this feature is now not part of the solidworks pcb. Anyway keep us up to date if you solve this issue.

I can relate to being unwell, and it’s been too much for myself as well to dig into troubleshooting this thing. Especially since I’ve tried this before, several times, with earlier versions and never could find a fix.

It can’t be something like file corruption or anything specific to a system install in particular, as I’ve done this many times from scratch and always get the same end result.

I’ve tried the 2016 and 2017 versions quite some time ago, and there were errors reported, as opposed to now, where no errors are reported until we get the one showing it doesn’t work when we try testing it.

I’ve tried the older versions back then with various system installs of win8 and win8.1, then later with early win10 installs as well.

Being done in virtual machines, I can start everything from scratch, and this is the case right now, as I did it again lately with the latest 1909 incarnation of win10.

I go through turning off all protections, firewall, virus, etc.

Running installers as admin, and now even trying to copy over the install stuff to a temp folder, and always get the same end result.

There is something consistent about it, but nothing points to the real issue. I’ve tried digging through logs, but I think there may be other logs somewhere else that «might» have more info, but couldn’t find those.

I’ve been wanting to give a try to this pcb stuff for a few years now and have yet to see it functional.

I even tried lately to get a front end for firebird (turbobird), hoping to have a peek into what’s there in the database (or not), but bumped against more trouble with the firebird client library not being found. I tried of course copying over that library, that does exist, into various locations where it’s supposed to be able to be found, without success.

So, back to square one, with a non functioning pcb services and no clue as to why the database tables can’t be found.

I know for sure the pcb services server software is indeed installed and does work and respond, as it does provide the login web page in a browser when accessing it, but then the same error keeps coming up when using the login credentials.

The pcb services server software doesn’t have dependencies other than the database beneath it, so it doesn’t require any other solidworks software to be installed, not even the sw pcb software, to be able to work. It can be stand alone and respond via a web interface in a browser.

Besides, that server software can be installed all by itself on a separate machine/server, and it can then be accessed across the network, and be administered via its interface in a browser.

I looked for firebird specific logs, hoping to find more clues, but couldn’t find anything useful.

I had experiencing this several time, but finally i found the solution, Solidworks PCB services won’t create a database if IIS are not running, by default they’re partially enabled in windows 10.

I enabled them by:

-> control panel -> programs -> Turn Windows features on or off -> Internet Information Services.

Enable it and all sub cores services. REBOOT

Then, repair Solidworks PCB services then login using the default credentials

Hope it helps you as it did 😉👍

I read your post a while back but did not have time to reply.

I will certainly give that a try next time I install solidworks. many thanks.

Message: Failed to retrieve User. Error retrieve data from database

Method: Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage)

Server stack trace:

at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)

at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)

at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)

at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:

at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

at Altium.Sdk.DxpAppServer.IDSServiceProxy.IDSPort.Login(LoginRequest request)

at Altium.Sdk.DxpAppServer.IDSServiceProxy.DSPortClient.Altium.Sdk.DxpAppServer.IDSServiceProxy.IDSPort.Login(LoginRequest request)

at Altium.Sdk.DxpAppServer.IDSClient.Login(String userName, String password, String identity, Boolean secureLogin)

at Altium.Sdk.DxpAppServer.Web.IDSMembershipProvider.ValidateUser(String userName, String password, String identity, IDSLoginResult& loginResult)

at Altium.Sdk.DxpAppServer.Web.IDSMembershipProvider.ValidateUserAndCreateTicket(String userName, String password, Boolean isPersistent, String identity, TimeSpan lifeTime)

at UserManagement.Controllers.AccountController.Login(LoginViewModel model, String returnUrl)

it’s really worked. thank bro so ! i am stucked on this two days before reading your commend.

I just joined in grabcad just to say Thank you very! much it worked! I was trying for months to find a solution but no luck until your post. I had to check every nested child services until the «Internet Information Services» shows a tick mark instead of black square and it’s done.

Glad to see people finding their way around this issue now.

Solid works can be a real pain on occasion.

Thank you man. This solution work wonderfully.

Источник