Hello again,
after I "played" some days with PGV, I wanted to import my GEDCOM File ( 300kb ). But after a time I get this error:
FastCGI Error
The FastCGI Handler was unable to process the request.
Error Details:
The FastCGI process exited unexpectedly
Error Number: -1073741819 (0xc0000005).
Error Description: Unknown Error
HTTP Error 500 - Server Error.
Internet Information Services (IIS)
So i looked around and find many hints to solve the problem:
- change the permissions for the folder
- replace the ntwdblib.dll with a newer one
- disable all extensions in php.ini (This is a problem, because PGV needed at least two extensions, in my case pdo.dll and pdo_mssql.dll
- change the value auf activity, execution parameters in the IIS , php.ini and fcgiext.ini
But nothing solved the problem.
So I imported a gedcom file with just 3 person and there were no problems.
After that I imported my gedcom file again and I get the error again.
When I look in the database i see that there are many entries in the tables after the import, but there are problems with the german umlauts.
After some tests I changed the value in gedcoms.php / imported from false inot true but then I recive error when I view some chart or statistics.
Anybody got an idea?
Stephan
P.s. the time after that I get the error is different (sometimes 20 sec, sometimes 2 minutes), it depends frome the setting of importing time
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
None of the developers use Microsoft IIS or SQL Server. This combination has received very little testing. I guess that 99% of people use Apache and MySQL.
The "HTTP Error 500 - Server Error." is difficult to diagnose. It means that an unexpected error occurred on your server. With apache, there would be a log file with more details of the problem. I guess IIS has the same thing, but I don't know what it is.
You said a tiny gedcom file imports OK, but a big one fails.
To diagnose the problem, perhaps take your big gedcom file, and keep removing records until it loads. This might identify either
(a) a record with a problem?
(b) a size limit?
<<after the import, but there are problems with the german umlauts.>>
This is normal. PGV stores data using UTF-8 encoding. IIRC MS SQL Server does not understand UTF-8, so it cannot display these characters. The "corruption" is reversed when PGV reads the data - so this is not a problem.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Also, if you are having a problem with importing a larger gedcom, set the import time VERY low, 10-15 seconds, and check both your PHP and PGV execution time limits and increase them to at least one (1) minute.
-Stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello again,
after I "played" some days with PGV, I wanted to import my GEDCOM File ( 300kb ). But after a time I get this error:
FastCGI Error
The FastCGI Handler was unable to process the request.
Error Details:
The FastCGI process exited unexpectedly
Error Number: -1073741819 (0xc0000005).
Error Description: Unknown Error
HTTP Error 500 - Server Error.
Internet Information Services (IIS)
So i looked around and find many hints to solve the problem:
- change the permissions for the folder
- replace the ntwdblib.dll with a newer one
- disable all extensions in php.ini (This is a problem, because PGV needed at least two extensions, in my case pdo.dll and pdo_mssql.dll
- change the value auf activity, execution parameters in the IIS , php.ini and fcgiext.ini
But nothing solved the problem.
So I imported a gedcom file with just 3 person and there were no problems.
After that I imported my gedcom file again and I get the error again.
When I look in the database i see that there are many entries in the tables after the import, but there are problems with the german umlauts.
After some tests I changed the value in gedcoms.php / imported from false inot true but then I recive error when I view some chart or statistics.
Anybody got an idea?
Stephan
P.s. the time after that I get the error is different (sometimes 20 sec, sometimes 2 minutes), it depends frome the setting of importing time
None of the developers use Microsoft IIS or SQL Server. This combination has received very little testing. I guess that 99% of people use Apache and MySQL.
The "HTTP Error 500 - Server Error." is difficult to diagnose. It means that an unexpected error occurred on your server. With apache, there would be a log file with more details of the problem. I guess IIS has the same thing, but I don't know what it is.
You said a tiny gedcom file imports OK, but a big one fails.
To diagnose the problem, perhaps take your big gedcom file, and keep removing records until it loads. This might identify either
(a) a record with a problem?
(b) a size limit?
<<after the import, but there are problems with the german umlauts.>>
This is normal. PGV stores data using UTF-8 encoding. IIRC MS SQL Server does not understand UTF-8, so it cannot display these characters. The "corruption" is reversed when PGV reads the data - so this is not a problem.
Also, if you are having a problem with importing a larger gedcom, set the import time VERY low, 10-15 seconds, and check both your PHP and PGV execution time limits and increase them to at least one (1) minute.
-Stephen