Stream: pascal
Topic: Error Installing Server binaries
Claudio Regonat (Oct 02 2019 at 21:53):
Hello, I'm having trouble installing the server binaries.
Grahame Grieve (Oct 02 2019 at 21:59):
ok sure. the install is rough
Claudio Regonat (Oct 02 2019 at 22:07):
I'm waiting the installer to see exactly what is the error...
Claudio Regonat (Oct 02 2019 at 22:19):
Ok, the error is: Initializing the database failed: Error: "The name hasExtension is not a valid function name"...
Claudio Regonat (Oct 02 2019 at 22:20):
line 1 col 47 in "QuestionnaireResponse.item.where(....
Claudio Regonat (Oct 02 2019 at 22:22):
the installer is that from http://www.healthintersections.com.au/FhirServer/, trying to setup a R4 server because I've to implement a client solution.
Grahame Grieve (Oct 02 2019 at 22:31):
The name hasExtension is not a valid function name
hmm
Claudio Regonat (Oct 02 2019 at 22:32):
yes
Grahame Grieve (Oct 02 2019 at 22:33):
that i'll have to debug - it looks like it is a valid function name
Claudio Regonat (Oct 02 2019 at 22:36):
ok, I've been playing with the github code, mostly with the client part. So I was trying to setup a server to play with it. I'm using SQLServer express.
Claudio Regonat (Oct 02 2019 at 22:38):
Where can I see that initialization code? Can I help with the debug part?
Grahame Grieve (Oct 02 2019 at 22:55):
well, maybe. that code arises during start up when it checks that all the invariants compile ok. And it looks like it should be valid... so I don't expect it will be an easy debug
Jose Costa Teixeira (Oct 03 2019 at 04:49):
Would it be useful to get the no-install version of the server for Claudio in the meanwhile?
Grahame Grieve (Oct 03 2019 at 05:08):
could help. but that code runs in any contexts. I'll be able to look at it on the plane no Sunday
Claudio Regonat (Oct 03 2019 at 21:49):
Would it be useful to get the no-install version of the server for Claudio in the meanwhile?
I've compiled the server from sources, and tried to configure and install from the command line, but I'm having trouble with the -mount command. Is there any documented procedure to install mannually?
Claudio Regonat (Oct 03 2019 at 21:56):
If I run "fhirserver -mount" the result is "No -cmd parameter - exiting now"
Grahame Grieve (Oct 03 2019 at 22:04):
you need to do -exec mount
Grahame Grieve (Oct 03 2019 at 22:05):
sorry, -cmd mount
Claudio Regonat (Oct 03 2019 at 22:15):
ok, I've found that on older messages. Thanks.
Jose Costa Teixeira (Oct 03 2019 at 22:42):
@Claudio Regonat got it working?
Claudio Regonat (Oct 03 2019 at 22:44):
no, not yet.
Claudio Regonat (Oct 03 2019 at 23:04):
ok, mounted the DB with r4 endpoint, got the db populated with tables, but the server doesn't start.
Jose Costa Teixeira (Oct 03 2019 at 23:06):
ok here are the commands that i use, these work:
to mount/remount:
FHIRServer.exe -cmd remount -password sa -ini ".\fhirserver.ini" -packages hl7.fhir.core#4.0.0 -endpoint r4 -mode open
Jose Costa Teixeira (Oct 03 2019 at 23:07):
to start:
FHIRServer.exe -cmd exec -ini ".\fhirserver.ini"
Jose Costa Teixeira (Oct 03 2019 at 23:07):
so, how is your fhirserver.ini?
Claudio Regonat (Oct 03 2019 at 23:09):
Ok, I'll uninstall the service, and try with that command.
It's the ini:
fhirserver.ini
Jose Costa Teixeira (Oct 03 2019 at 23:12):
does look ok from here...
Claudio Regonat (Oct 03 2019 at 23:14):
If I run your command I get
"You must provide a admin passowrd as a parameter to the command"
Jose Costa Teixeira (Oct 03 2019 at 23:16):
hmm i swear i had it working.
Claudio Regonat (Oct 03 2019 at 23:16):
Sorry, wrong command. It now asks for an Authorization file
Grahame Grieve (Oct 03 2019 at 23:18):
asks for an Authorization file
What is the exact wording?
Claudio Regonat (Oct 03 2019 at 23:19):
"No authorization file found"
Grahame Grieve (Oct 03 2019 at 23:20):
according the source, you need this in your ini file:
[web] clients=[file]
where file is the name of an ini file that can be empty
Jose Costa Teixeira (Oct 03 2019 at 23:22):
right. in the files that come with the installer, this is auth.ini
Claudio Regonat (Oct 04 2019 at 01:58):
Well, I'm having an AV: FHIR.Ucum.Services._ZN4Fhir4Ucum8Services13TUcumServices... (Line 409, "FHIR.Ucum.Services.pas" + 5) while mounting the database.
Grahame Grieve (Oct 04 2019 at 02:02):
this is something I need to sort out - the infrastructure assumes that UCUM is loaded. So you have to have a line in your ini file like
Grahame Grieve (Oct 04 2019 at 02:02):
[terminologies] ucum=type: ucum; source: C:\work\fhirserver\Exec\ucum-essence.xml; when-testing: true
Claudio Regonat (Oct 04 2019 at 02:12):
ok, let's try again. Thanks for your help.
Claudio Regonat (Oct 04 2019 at 02:29):
Another error: Attempt to reuse ODBC connection "BuildIndexes" while it is in use.
Claudio Regonat (Oct 04 2019 at 02:31):
the server starts ok, and seems to work ok...
Grahame Grieve (Oct 04 2019 at 02:50):
ok thanks. That's a background error that will re-occur but won't be noticeable to the clients unless they perform a particular kind of terminology query
Grahame Grieve (Oct 04 2019 at 04:06):
so I can't reproduce that. If you can reproduce it, can you debug it? (specifically, tell me, what is the value of FSQL on the connection that is prepared (line 1021 FHIR.Database.Manager)
Claudio Regonat (Oct 04 2019 at 20:40):
so I can't reproduce that. If you can reproduce it, can you debug it? (specifically, tell me, what is the value of FSQL on the connection that is prepared (line 1021 FHIR.Database.Manager)
well, I can't reproduce it. All seems to work ok now. Thanks.
Grahame Grieve (Oct 04 2019 at 20:44):
ok thanks.
Grahame Grieve (Oct 04 2019 at 20:45):
it's one of those cases where I'm actually disappointed that it works :sweat:
Claudio Regonat (Oct 07 2019 at 13:53):
it's one of those cases where I'm actually disappointed that it works :sweat:
Yes, I agree.... Could be that the ODBC connection doesn't get released some times? Maybe during debug phase, the connection has more time to be freed?.
Another question, this maybe unrelated. How can I install packages from simplifier.net to my local server?. I've tried with package manager with the server manager. it installs to the system cache, or user cache, but the server doesn't load these packages.
Grahame Grieve (Oct 07 2019 at 14:21):
it loads during install only, using -packages
Claudio Regonat (Oct 07 2019 at 20:54):
Grahame, trying to install simplifier.net, I've to remount the db and the error happened again. As debuggin with the IDE it doesn't happen, I've logged the SQL: Update ValueSets set NeedsIndexing = 0, Error = 'Unable to locate code 223366009' where ValueSetKey = 7 ... Hope this would be useful.
Grahame Grieve (Oct 08 2019 at 00:02):
great. found the problem.
Grahame Grieve (Oct 08 2019 at 00:02):
thanks
Last updated: Apr 12 2022 at 19:14 UTC
