Problem:
When using the SQL Wizard the following error is being produced:
X001:= Cannot perform 'open (3) on file 'C:\\mfuser\\config\\tmp\\_1_0'.
The DDLbeing used is attached.
The error is occurring on the CREATE TABLE command.
Resolution:
The problem relates to either the tmp folder doesn't exist or the README file within the tmp folder is missing.
To resolve:-
1. Exit from MFE making sure that the XDB server is stopped.
2. Create README file in the c:\\mfuser\\config\\tmp folder, this file needs to exist when using XDB.
#EnterpriseDeveloper
#MFDS