Fmincon in Matlab 2014a

本文介绍了一种解决Matlab中fmincon函数出现特定错误的方法,即通过设置算法选项为'trust-region-reflective'来避免因Hessian选项设置而导致的问题。

Error using fmincon (line 816), Hessian option set to 'on' but no Hessian function provided in options HessFcn nor in HessMult". This does not happen with previous Matlab version.


Solution:

specifying the algorithm used as trust-region-reflective i.e. adding 'Algorithm','trust-region-reflective' to the options


add the  

'Algorithm','trust-region-reflective' 

to the start of the options



http://www.mathworks.com/matlabcentral/answers/154689-fmincon-in-matlab-2014a

### Cause: java.sql.SQLSyntaxErrorException: ORA-01790: 式には対応する式と同じデータ型を持つ必要があります ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-01790: 式には対応する式と同じデータ型を持つ必要があります ] with root cause Error : 1790, Position : 213, Sql = MERGE INTO A01_PROJECT_MEMBER t USING ( SELECT :1 AS PROJECT_ID, :2 AS EMPLOYEE_ID, :3 AS EMPLOYEE_NAME, :4 AS ROLE, :5 AS START_DATE, :6 AS END_DATE, 0 AS DEL_FLG, :7 AS INSERT_USER_ID, :8 AS UPDATE_USER_ID FROM dual UNION ALL SELECT :9 AS PROJECT_ID, :10 AS EMPLOYEE_ID, :11 AS EMPLOYEE_NAME, :12 AS ROLE, :13 AS START_DATE, :14 AS END_DATE, 0 AS DEL_FLG, :15 AS INSERT_USER_ID, :16 AS UPDATE_USER_ID FROM dual ) s ON ( t.PROJECT_ID = s.PROJECT_ID AND t.EMPLOYEE_ID = s.EMPLOYEE_ID AND t.START_DATE = s.START_DATE ) WHEN MATCHED THEN UPDATE SET t.EMPLOYEE_NAME = s.EMPLOYEE_NAME, t.ROLE = s.ROLE, t.END_DATE = CURRENT_TIMESTAMP, t.DEL_FLG = s.DEL_FLG, t.INSERT_USER_ID = s.INSERT_USER_ID, t.INSERT_TIME = t.INSERT_TIME, t.UPDATE_USER_ID = s.UPDATE_USER_ID, t.UPDATE_TIME = CURRENT_TIMESTAMP WHEN NOT MATCHED THEN INSERT ( PROJECT_ID, EMPLOYEE_ID, EMPLOYEE_NAME, ROLE, START_DATE, END_DATE, DEL_FLG, INSERT_USER_ID, INSERT_TIME, UPDATE_USER_ID, UPDATE_TIME ) VALUES ( s.PROJECT_ID, s.EMPLOYEE_ID, s.EMPLOYEE_NAME, s.ROLE,    CURRENT_TIMESTAMP, null, s.DEL_FLG, s.INSERT_USER_ID, CURRENT_TIMESTAMP, s.UPDATE_USER_ID, CURRENT_TIMESTAMP ), OriginalSql = MERGE INTO A01_PROJECT_MEMBER t USING ( SELECT ? AS PROJECT_ID, ? AS EMPLOYEE_ID, ? AS EMPLOYEE_NAME, ? AS ROLE, ? AS START_DATE, ? AS END_DATE, 0 AS DEL_FLG, ? AS INSERT_USER_ID, ? AS UPDATE_USER_ID FROM dual UNION ALL SELECT ? AS PROJECT_ID, ? AS EMPLOYEE_ID, ? AS EMPLOYEE_NAME, ? AS ROLE, ? AS START_DATE, ? AS END_DATE, 0 AS DEL_FLG, ? AS INSERT_USER_ID, ? AS UPDATE_USER_ID FROM dual ) s ON ( t.PROJECT_ID = s.PROJECT_ID AND t.EMPLOYEE_ID = s.EMPLOYEE_ID AND t.START_DATE = s.START_DATE ) WHEN MATCHED THEN UPDATE SET t.EMPLOYEE_NAME = s.EMPLOYEE_NAME, t.ROLE = s.ROLE, t.END_DATE = CURRENT_TIMESTAMP, t.DEL_FLG = s.DEL_FLG, t.INSERT_USER_ID = s.INSERT_USER_ID, t.INSERT_TIME = t.INSERT_TIME, t.UPDATE_USER_ID = s.UPDATE_USER_ID, t.UPDATE_TIME = CURRENT_TIMESTAMP WHEN NOT MATCHED THEN INSERT ( PROJECT_ID, EMPLOYEE_ID, EMPLOYEE_NAME, ROLE, START_DATE, END_DATE, DEL_FLG, INSERT_USER_ID, INSERT_TIME, UPDATE_USER_ID, UPDATE_TIME ) VALUES ( s.PROJECT_ID, s.EMPLOYEE_ID, s.EMPLOYEE_NAME, s.ROLE,    CURRENT_TIMESTAMP, null, s.DEL_FLG, s.INSERT_USER_ID, CURRENT_TIMESTAMP, s.UPDATE_USER_ID, CURRENT_TIMESTAMP ), Error Msg = ORA-01790: 式には対応する式と同じデータ型を持つ必要があります 哪个地方报错了
07-25
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值