Forum Discussion
FICO
2 years agoCommunity Manager
Mosel: Error located at line 136 of `bin\model.mos'. Mosel: Dumping call stack (2/2): Mosel: #0 line 136 of `bin\model.mos' Mosel: #1 line 980 of `bin\model.mos'
i got this error when i was running the for loop which i mentioned in the previous question now in the line 136 i am connecting to database using sqlconnect and connectionstring and executing a insert query so inside the for loop it will be calling one procedure and inside that i am connection to database and executing insert query.
plzz help me out on this as soon as possible
13 Replies
- FICOCommunity Manager
Was there any other message displayed before the 'Error located at line...'?
- FICOCommunity Manager
connection to server at "localhost" (::1), port 5432 failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
, SQLSTATE=08001
ODBC: No connection.
this error message was there and i have made sure there was no connection issue the port forwarding was working fine
plzz answer as soon as possible
- FICOCommunity Manager
The error message indicates that the database connection has failed: Have you verified the connection string setup with your database administrators, or if you rely on a DSN, verified that the latter is configured correctly?
- FICOCommunity Manager
yaa i have verified actually it was working fine till friday there wasnt any such issue
Mosel: Dumping call stack (2/2):
can u tell me what can cause this error ?
- FICOCommunity Manager
The message 'dumping call stack' indicates that the reported error occurs within a subroutine that gets called from some other location in the Mosel program; it allows you to trace exactly where and how the problem occurs, but it is not an error in itself (indeed, you can display a call stack at any time via the subroutine dumpcallstack (fico.com) provided that the program has been compiled with debug information, that is, using compilation flag -g or -G).
- FICOCommunity Manager
okk so can be the error bcoz of multiple times calling the same procedure and executing the same sql statement or is just a connection issue
- FICOCommunity Manager
The error message you have reported earlier says that the connection failed: is this on the first attempt (=first iteration calling the subroutine) or on a subsequent one? If you need to invoke several SQL statements, I would recommend to connect to the database only once (from the first iteration, or before invoking this subroutine), keep the connection open through the desired number of iterations and close the connection after the last one.
- FICOCommunity Manager
okk sure thank for your suggestion i will try once again if its giving same issue i will do as u suggested
- FICOCommunity Manager
Stopping...
Mosel: Interrupted at line 136 of `model.mos'.
Mosel: Dumping call stack (2/2):
Mosel: #0 line 136 of `bin\model.mos'
Mosel: #1 line 980 of `bin\model.mos'
still i am getting the issue this time i didnt get any error related to connection the error mentioned above was the only error message i got
and along with this can u suggest me how can i make a variable which is of type set nonfinalize so that i can change its value later
i am using options noautofinal but this will make all the variables globally non final as far as i know so kindly suggest something for this
plzz solve my issue as soon as possible
- FICOCommunity Manager
The message 'Interrupted at line' is displayed when a model receives a hard stop (like Ctrl-C).
Regarding the automatic finalization feature: please see my answer to your separate post: