The mcc compiler generates an SQL exception for even the simplest Matlab scripts.

Simple Matlab function - fred.m

function main

fprintf(1,'Hello\n');

Compile command:

mcc -m -C -v fred.m

Error:

Compiler version: 7.0 (R2018b)

Dependency analysis by REQUIREMENTS.

Unexpected error while determining required deployable files. Compilation terminated. Details:

Error using matlab.depfun.internal.database.SqlDbConnector/doSql

Received exception upon attempting an operation. Exception: [SQL error or missing database file:%2Fapps%2Fshare64%2Fdebian7%2Fmatlab%2F9%2E5%2Ftoolbox%2Fmatlab%2Fdepfun%2F%2Bmatlab%2F%2Bdepfun%2F%2Binternal%2Fpcm%5Fglnxa64%5Fdb?mode=ro&vfs=unix-none. (near "AND": syntax error)]. Details: [SELECT Product.External_Product_ID FROM Product WHERE Product.ID IN (SELECT Product_Dependency.Client FROM Product, Product_Dependency WHERE Product.External_Product_ID = AND Product_Dependency.Service = Product.ID);].

Error in matlab.depfun.internal.ProductComponentModuleNavigator/doSql (line 988)

obj.SqlDBConnObj.doSql(SqlCmd);

Error in matlab.depfun.internal.ProductComponentModuleNavigator/MatlabModulesInMatlabRuntime (line 809)

obj.doSql(query);

Error in matlab.depfun.internal.Schema/expect (line 670)

list = nv.MatlabModulesInMatlabRuntime();

Error in compiler_rules (line 8)

Error in matlab.depfun.internal.Schema/addRules (line 196)

feval(fcn, obj);

Error in matlab.depfun.internal.Completion>targetSchema (line 2860)

s.addRules(rulesFile);

Error in matlab.depfun.internal.Completion>schemaMap (line 2822)

rulesMap(tgt) = targetSchema(target);

Error in matlab.depfun.internal.Completion (line 2266)

obj.Schema = schemaMap(obj.Target);

Error in matlab.depfun.internal.requirements (line 208)

c = matlab.depfun.internal.Completion(items, tgt, 'useDatabase');

Error in matlab.depfun.internal.mcc_call_requirements (line 8)

[parts, resources, exclusions] = matlab.depfun.internal.requirements(items, varargin{:});

Answer 1

[LP]

I'm getting a similar issue frequently as well. My soloution is to restart Matlab which is tiresome.

Unexpected error while determining required deployable files. Compilation terminated. Details:
Error using matlab.depfun.internal.database.SqlDbConnector/doSql
Received exception upon attempting an operation. Exception: [SQL error or missing database file: