ClicSAND error HO3

73 views
Skip to first unread message

Tapiwa Chamoto

unread,
Nov 8, 2021, 1:23:15 PM11/8/21
to OSeMOSYS
Hi 

im getting an error after i have imputted all the data into the interface and im now trying to run the model.

------------------------------------------------------------------------------------------------------------------------------------------------------
Data file: C:\Users\Tapiwa Chamoto\Desktop\MODELING\HO3\CCG-SAND Interface v.12_HO3.xlsm.txt
Model file: C:\Users\Tapiwa Chamoto\Desktop\MODELING\HO2\OSeMOSYS_code.txt
GLPSOL Output file: C:\Users\Tapiwa Chamoto\Desktop\MODELING\HO3\CCG-SAND Interface v.12_HO3.xlsm.lp
Results file: C:\Users\Tapiwa Chamoto\Desktop\MODELING\HO3\CCG-SAND Interface v.12_HO3.xlsm.results.txt
Log file: C:\Users\Tapiwa Chamoto\Desktop\MODELING\HO3\CCG-SAND Interface v.12_HO3.xlsm20211108193451.log.txt
------------------------------------------------------------------------------------------------------------------------------------------------------
Error extracting data:
Unable to cast COM object of type 'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).

this is the error. i have also attached the a snip of clicSand 

please help
ho3 error.JPG

Rudolf Yeganyan

unread,
Nov 10, 2021, 4:27:33 AM11/10/21
to OSeMOSYS
Hi, 

This may be because you have not saved the files on the C Disk. Please try saving it there and running the model again. 

If this does not work, please write here again.

Best regards,

Rudolf

Rudolf Yeganyan

unread,
Nov 10, 2021, 4:48:21 AM11/10/21
to OSeMOSYS
Also, please have a look at the videos here, this could help:


Best,

Rudolf

Tapiwa Chamoto

unread,
Nov 24, 2021, 2:13:22 PM11/24/21
to osem...@googlegroups.com
Hey Rudolf

hope this finds you well. im sorry to be doing this at the end of the week but im finally getting things in order and this problem is still there...i really dont know where to start.

i did put the files in the c drive as you suggested and it still didnt work 

--
You received this message because you are subscribed to the Google Groups "OSeMOSYS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to osemosys+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/osemosys/a47aa9a7-c315-49fd-8d77-f86283d1bf5dn%40googlegroups.com.

Hassen Nabilah

unread,
Nov 25, 2021, 12:24:33 AM11/25/21
to OSeMOSYS
Go to your pc settings --> Add or Remove Programs --> Apps and Features --> Office --> Modify --> Quick Repair (This problem is mostly caused by incorrect COM Interop settings in the Windows registry.)

Tapiwa Chamoto

unread,
Nov 25, 2021, 2:16:14 AM11/25/21
to osem...@googlegroups.com
it didnt work. si have unistalled my office, installing it again and also updating my windows. i think its a problem that ive had with my pc for while just piling up. wish me luck

You received this message because you are subscribed to a topic in the Google Groups "OSeMOSYS" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/osemosys/67xttmIGUlc/unsubscribe.
To unsubscribe from this group and all its topics, send an email to osemosys+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/osemosys/CAO8ywxNB-mRQkYPy03Xp44m_CzAA7yGMExdJy0GAKvMHFsSQUA%40mail.gmail.com.

Rudolf Yeganyan

unread,
Nov 25, 2021, 4:15:59 AM11/25/21
to OSeMOSYS
Hi Tapiwa, 

Try re-installing ClicSAND, and check that you have installed glpk solver correctly. If that does not work, let me know.

Best,

Rudolf

Tapiwa Chamoto

unread,
Nov 25, 2021, 4:42:34 AM11/25/21
to osem...@googlegroups.com
Hey Rudolf

Finally working, let me crush this HOs now...

thank for the assistance 

Tapiwa 

hantc...@gmail.com

unread,
Nov 27, 2021, 1:08:23 PM11/27/21
to osem...@googlegroups.com, Tapiwa Chamoto

5 sur 427

osemosys exercise 3

14 vues
à OSeMOSYS
Please group  members can anyone help  me    debug this issue
thanks

------------------------------------------------------------------------------------------------------------------------------------------------------
Data file: C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.txt
Model file: C:\OSeMOSYSand Fextool\HO3\OSeMOSYS_code.txt
GLPSOL Output file: C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.lp
Results file: C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.results.txt
Log file: C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm20211124115330.log.txt
------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------
Running C:\Program Files\clicSAND\utils\glpsol.exe --check -m "C:\OSeMOSYSand Fextool\HO3\OSeMOSYS_code.txt" -d "C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.txt" --wlp "C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.lp"
------------------------------------------------------------------------------------------------------------------------------------------------------
GLPSOL: GLPK LP/MIP Solver, v4.61
Parameter(s) specified in the command line:
 --check -m C:\OSeMOSYSand Fextool\HO3\OSeMOSYS_code.txt -d C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.txt
 --wlp C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.lp
Reading model section from C:\OSeMOSYSand Fextool\HO3\OSeMOSYS_code.txt...
C:\OSeMOSYSand Fextool\HO3\OSeMOSYS_code.txt:1015: warning: final NL missing before end of file
1015 lines were read
Reading data section from C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.txt...
C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.txt:20013: 3 items missing in data group beginning with 1
Context:  0 0 0 0 0 0 0 0 0 0 ; param CapitalCost default 0 , 0001 :=
MathProg model processing error
------------------------------------------------------------------------------------------------------------------------------------------------------
Running CBC\bin\cbc.exe "C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.lp" ratio 0,05 solve -solu "C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.results.txt"
------------------------------------------------------------------------------------------------------------------------------------------------------
Welcome to the CBC MILP Solver
Version: 2.7.5
Build Date: Nov 10 2011
Revision Number: 1759

command line - CBC\bin\cbc.exe C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.lp ratio 0,05 solve -solu C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.results.txt (default strategy 1)
Unable to open file C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.lp
String of 0,05 is illegal for double parameter ratioGap value remains 0
** Current model not valid
** Current model not valid
No match for C:\OSeMOSYSand Fextool\HO3\SAND_Interface_HO3.xlsm.results.txt - ? for list of commands
Total time (CPU seconds):       0.00   (Wallclock seconds):       0.00
Please this is error I am having After tuning 


On mer., nov. 24, 2021 at 20:13, Tapiwa Chamoto
Reply all
Reply to author
Forward
0 new messages