Bug report #6119
EVIS: invalid layer in project
|Affected QGIS version:||1.8.0||Regression?:||No|
|Operating System:||Windows||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||no timely feedback|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||15458|
Windows XP SP3
QGIS Version 1.8.0-Lisboa
Code Revision: 6416f38
I created some projects and for two of them that are based upon an ODBC that points to a XLS source file created using the eVis connexion manager I have a crash. "Application défaillante qgis.exe, version 0.0.0.0, module défaillant delimitedtextprovider.dll, version 0.0.0.0, adresse de défaillance 0x00015dd1."
Here's an extract of the content of the QGIS project on the layer named "Bureaux" based upon the ODBC with the same name which seems suspicious to me:
<id>Bureaux20120726121133312</id> <datasource>file:../../../../TMP/qt_temp.eT5972?delimiter=%09&delimiterType=regexp&xField=X&yField=Y</datasource> <title></title> <abstract></abstract> <layername>Bureaux</layername> <srs> <spatialrefsys> <proj4>+proj=lcc +lat_1=44 +lat_2=49 +lat_0=46.5 +lon_0=3 +x_0=700000 +y_0=6600000 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs</proj4> <srsid>10089</srsid> <srid>310024140</srid> <authid>IGNF:LAMB93</authid> <description>Lambert 93</description> <projectionacronym>lcc</projectionacronym> <ellipsoidacronym>IGNF:ELG037</ellipsoidacronym> <geographicflag>false</geographicflag> </spatialrefsys> </srs> <transparencyLevelInt>255</transparencyLevelInt> <provider encoding="System">delimitedtext</provider>
I attached the additional error infos and my Evis connexion manager info.
#2 Updated by ikc66 ikc666 over 8 years ago
I agree that the change done in the revision #23a34121 on src/providers/delimitedtext/qgsdelimitedtextprovider.cpp should prevent crashing again but this is only the consequence of a bad record of the ODBC infos (whatever the source: MSSQL server, Excel file, CSV, etc).
I'm new to QGIS and don't know exactly the way it works to save the project while using an ODBC datasource but in fact each time he does the following kind of bad record for the source in the project file:
I may be wrong, but I cannot see the correction of the ODBC datasource recording in the revision 23a34121. Do I need to create another issue? If so, is it in the main thread or in the plugins?
#3 Updated by Jürgen Fischer over 8 years ago
- Status changed from Closed to Reopened
- Resolution deleted (
- Priority changed from Severe/Regression to Normal
- Subject changed from Error in delimitedtextprovider.dll while openning saved projects on QGIS 1.8 to EVIS: invalid layer in project
- Category changed from Project Loading/Saving to C++ Plugins
#5 Updated by Andre Joost about 8 years ago
evis creates a delimited text file, which gets deleted after closing the program. If I save it before closing, and restore it to the temp folder, the project reopens.
Strangely enough, that file will not be deleted on closing the project anymore...
But that would not be a live connection to the database anymore. Storing the database connection parameters would be better (like for spatialite databases).