Skip to content

sqlite3.OperationalError: no such table: images #7

@ujjawalcse

Description

@ujjawalcse

I have only downloaded some PAN and MSI images (not completely) as you can seen below,

ssr_msi

ssr_pan

Then I changed the path in the MVS3DM_Explorer.json and executed the code below ,

python3 stereo_pipeline.py --config_file aoi_config/MVS3DM_Explorer.json

{'dataset_dir': '/home/ujjawal/my_work/object_recon/SatelliteSurfaceReconstruction/satellite_imgs/WV3/PAN', 'work_dir': '/home/ujjawal/my_work/object_recon/SatelliteSurfaceReconstruction/VisSatSatelliteStereo/data2/kz298/explorer', 'bounding_box': {'zone_number': 21, 'hemisphere': 'S', 'ul_easting': 354052.3651180889, 'ul_northing': 6182702.10540914, 'width': 712.9748326897388, 'height': 651.4791190521792}, 'steps_to_run': {'clean_data': True, 'crop_image': True, 'derive_approx': True, 'choose_subset': True, 'colmap_sfm_perspective': True, 'inspect_sfm_perspective': False, 'reparam_depth': True, 'colmap_mvs': True, 'aggregate_2p5d': True, 'aggregate_3d': False}, 'alt_min': -30.0, 'alt_max': 120.0}
step clean_data:	finished in 0.010855866666666667 minutes
step crop_image:	finished in 0.04069456666666667 minutes
step derive_approx:	finished in 0.02496066666666667 minutes
step choose_subset:	finished in 1.0033333333333333e-05 minutes
Traceback (most recent call last):
  File "stereo_pipeline.py", line 511, in <module>
    pipeline.run()
  File "stereo_pipeline.py", line 115, in run
    self.run_colmap_sfm_perspective()
  File "stereo_pipeline.py", line 346, in run_colmap_sfm_perspective
    colmap_sfm_perspective.run_sfm(work_dir, sfm_dir, init_camera_file, weight)
  File "/home/ujjawal/my_work/object_recon/SatelliteSurfaceReconstruction/VisSatSatelliteStereo/colmap_sfm_perspective.py", line 72, in run_sfm
    reproj_err_threshold, reproj_err_threshold, reproj_err_threshold)
  File "/home/ujjawal/my_work/object_recon/SatelliteSurfaceReconstruction/VisSatSatelliteStereo/colmap_sfm_commands.py", line 75, in run_point_triangulation
    create_init_files(db_file, template_file, out_dir)
  File "/home/ujjawal/my_work/object_recon/SatelliteSurfaceReconstruction/VisSatSatelliteStereo/colmap_sfm_utils.py", line 110, in create_init_files
    table_images = db.execute("SELECT * FROM images")
sqlite3.OperationalError: no such table: images

I'm missing one {work_dir}/colmap/sfm_perspective/init_ba_camera_dict.json in sfm_stage

Can you @Kai-46 please have a look into this issue?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions